ORA-01704: string literal too long
568998May 2 2010 — edited Aug 23 2012Is there any way using generic sql to insert a string longer than 4000 chars into a CLOB? I can't use PLSQL it has to be generic sql using a quoted string. But I can do any specific Oracle code before loading the file containing the sql.
Example,
<Oracle specific code>
insert into test (col1) values ('<string longer than 4000 chars');