SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

assign a value to a clob

Dibyendu ChakrabortyJul 31 2008 — edited Aug 1 2008

I have a packaged procedure p1 (p_clob in clob, p_clob_out out clob).

I will have to test the procedure whether it is running fine or not. I am getting a biiiiig string which is of size >32kb (say 76 KB).
I need to execute the procedure.
Please tell me how will I do that?

whenever I am calling the procedure p1(that biiiig string, outxml) it is giving an error string lateral too long.

Please tell me how to do that. It is very urgent.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 29 2008

Added on Jul 31 2008

10 comments

3,981 views