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!

ORA-01704: string literal too long for CLOB colum

user4295847May 30 2013 — edited Jun 4 2013
Hi,

I'm trying to execute sql script containing a lot of insert into statements.

Insert into table (clob_column) values ("value of 5500 characters");
I get the below error message. Please let me know how do resolve this issue without PL/SQL ?

ORA-01704: string literal too long
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2013
Added on May 30 2013
7 comments
55,334 views