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!

how to Insert more than 32767 character in CLOB column?

3835949Nov 26 2019 — edited Nov 29 2019

Hello,

I need to store one JSON in table and for that I have created one table with datatype CLOB, But when I am going to insert in this table it throwing error that "SQL Error: ORA-01704: string literal too long"

I have search for solution and found that I can insert it using bind variables, But I did not find any proper example.

I am using procedure to save this JSON request which will be call from JAVA.

Comments
Post Details
Added on Nov 26 2019
8 comments
17,780 views