How to write in a NCLOB with DBMS_LOB.write ?

Hi,

When I compile (under oracle schema manager) the following function, I get this error message "line 8: PLS-00560 character set mismatch"

(result in VARCHAR2 character set ANY_CS, pos in INTEGER) return CLOB is

amt INTEGER := 2000;
dest_lob CLOB ;

begin
  select text into dest_lob from test4;
  dbms_lob.write(dest_lob,amt,pos,'e');
end;

(the table "test4" is composed of an NCLOB which name is text)
Received on Fri Jul 21 2000 - 00:00:00 CEST