All
I have requirement in my pl/sql :

declare
l_clob clob
str varchar2(4000);
begin
str='This is test clob';
l_clob:=str;
end;

Iam getting a string value as an input and When i try to assign a string
into clob variable , iam getting the below error

ORA-22275: invalid LOB locator specified

Can any one help me on this ?

Thanks
Kumat

Oracle LazyDBA home page