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]
Good Judgement comes from Experience.
Experience comes from Bad Judgement