hai

i have a tabe like this
Table name :test with fields
A number(20)
B clob


When i give
SQL> insert into test values(1,'sdfsdf');
it gets inserted successfully.

but how to do in an anonymous block by assigning to a temportary clob variable

declare
d clob;
begin
d:='sdf' - this statement is throwing error
insert into test values(1,d);
commit;
end;
/

so when i want to assign a clob type to a clob variable what should i do

also when i want the input variable (clob type) to be passed to a procedure what should i do.

[Edited by sona on 09-04-2002 at 06:59 AM]