CLOB to VARCHAR2

Hi,

I am trying to convert CLOB to VARCHAR2 in PL/SQL. First I read CLOB from the table.
Then I try to convert CLOB to VARCHAR2. ls_data := sys.dbms_lob.substr(lbl_data, 1, sys.dbms_lob.GetLength(lbl_data));
sys.dbms_output.put_line(ls_data);

But I don't get any result.
Can anyone explain what should I do?

Thanks

 Primoz Received on Thu Nov 25 1999 - 01:23:45 CST