I want to insert a 200k character data in a column using sqldev. I tried basic insert but it says string too long. may I know how can I insert it?

Asked Apr 12 '22 at 09:23

Active Apr 12 '22 at 09:23

Viewed 17 times

I am using oracle sql developer and I need to insert a 200k data on one cell the data type of the column is already set to clob. However when I tried to insert the data, it says SQL Error: ORA-01704 : string literal too long

asked Apr 12 '22 at 09:23

Yhza Cy

May be duplicated: https://stackoverflow.com/questions/13945710/error-ora-01704-string-literal-too-long – Pham X. Bach Apr 12 '22 at 09:28

I want to insert a 200k character data in a column using sqldev. I tried basic insert but it says string too long. may I know how can I insert it?

0 Answers0