Hi,
How can you assign a text to a CLOB column defined in the DECLARE section of PL/SQL.I am getting an error on wrong type.
i.e..
SQL> l
1 declare
2 c clob ;
3 BEGIN
4 c := 'This is a test';
5* END;
SQL> /
c := 'This is a test';
*
ERROR at line 4:
ORA-06550: line 4, column 6:
PLS-00382: expression is of wrong type
ORA-06550: line 4, column 1:
PL/SQL: Statement ignored
Yuval Arnon
