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

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

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]