CLOB > 32k

We're trying to insert a value that is like 50,000 characters long into a CLOB column from PL/SQL. It is passed in as a parameter to a CLOB type.

Now, from what I am reading 32k is the limit for any variable in PL/ SQL. First, what is the best way to get around this. Second, if 32k is the largest, the how does one insert objects, photos, etc into an object column if PL/SQL can only handle 32k? Received on Wed Jun 02 2010 - 09:49:22 CDT