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.