i have a tabe like this
Table name :test with fields
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:='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]
Good Judgement comes from Experience.
Experience comes from Bad Judgement