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 with a string longer than 32767

299979Sep 30 2005 — edited Dec 26 2007

hello,

is there a possibility to make an execute immediate with a statement, that is longer than the 32767 max. bytes for varchar`s? We get in a CLOB SQL-Statements with data that are longer than 32767. It would be easy if it were possible to make an execute immediate but because of the length limit it seems impossible. Does anybody know an alternative way to execute the sql-statements in the CLOB-Column?
??
Anna

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 23 2008

Added on Sep 30 2005

12 comments

23,627 views