ORA-01704: string literal too long

amar

07-18-2001, 08:27 AM

:)

You get the error because you are executing a sql statement.
In SQL the max of varchar2 is 4000 bytes and hence the error. Modify your code snippet to something like the following and it should work. (it becomes a pl/sql program).

declare
myClobVar varchar2(32767) := 'string';
begin
update tableWithClob set clobcol = myClobVar;
end;

-amar