Skip to Main Content
Forums

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!

EXECUTE IMMEDIATE STATMENT PASSING CLOB VARIABLE TYPE

678289Jan 5 2009 — edited Jan 21 2009
Hi,

We have writen a package to build a a string in CLOB variable and pased it through DYNAMIC sql statment. It work file when there are less than 72000 characters in the club varaible. But when it is over 72000 characters, the dynamic execute statement failed over with ther error message of invalid data type.

Can you please help why it can only handle 72,000 characters instead of 2GB of data.

Bill.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 18 2009
Added on Jan 5 2009
#variable
7 comments
5,269 views