Skip to Main Content

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!

CLOB issue in inserting

itzkashiFeb 25 2016 — edited Feb 26 2016

i have a table t1 (qry varchar2(10), qry_desc clob ) and i am trying to insert a string in qry_desc col using sql developer which is more than 5000 characters and getting the below error.

Error at Command Line:2 Column:1

Error report:

SQL Error: ORA-01704: string literal too long

01704. 00000 -  "string literal too long"

*Cause:    The string literal is longer than 4000 characters.

*Action:   Use a string literal of at most 4000 characters.

           Longer values may only be entered using bind variables.

          

i am specifying CLOB but still i am getting this error. Could you please let me know what is the issue and how should i do it.

Thanks in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 25 2016
Added on Feb 25 2016
2 comments
7,656 views