Oracle Database Discussions

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!

maximum length of SQL statement Oracle supports

621979Oct 15 2008 — edited Oct 16 2008

Hi,

Getting the below mentioned error when I am trying to execute the sql statement of length( 8000 characters). The datatype of column I am storing this value is of type CLOB.
What is the maximum length of SQL statement that Oracle(10.2.0.3) supports?
"ORA-01704: string literal too long"

Please let me know how to resolve this error?

Regards,
Dayakar

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 13 2008

Added on Oct 15 2008

#general-database-discussions

4 comments

518 views