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!

Limitation for CLOB columns? - ORA-01704: string literal too long

608492Mar 20 2009 — edited Mar 20 2009
Hello!

I'm trying to update a CLOB column with more than 35000 characteres, but I get "ORA-01704: string literal too long".

The code:

declare
l_clob clob;
begin
update test set test = empty_clob()
WHERE ID = 1
returning test into l_clob;
dbms_lob.write( l_clob, length('A...here 35000xA...A'), 1,'A...here 35000xA...A');
end;

Is there any limitation for CLOB columns?

Thanks for help.

Daniel
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 17 2009
Added on Mar 20 2009
7 comments
1,130 views