Oracle Forms (MOSC)

MOSC Banner

How do you get around the 32760 char PL/SQL limit for Long fields in Forms?

edited Jun 3, 2010 4:19AM in Oracle Forms (MOSC) 14 commentsAnswered
In Forms I need to copy the contents of a field (defined as a clob in the database) on the database block into a field on a non-database block (where the user will edit it as needed) and then copy it back to the database block field when done. This works fine, except when the length is more than 32760 characters (the PL/SQL limit). How can I make this work?

I'm using Forms 10gR2.

Thanks,

Dan

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center