SQL & PL/SQL

Hello ,


I am trying to use clob to store the result set of tyhe cursor .
However , that is giving me an error.

Please advise. Thanks in advance



txt clob := empty_clob();

begin

....


loop
dbms_output.put_line(length(c.data_string));
--dbms_lob.writeappend(txt, length(c.data_string), c.data_string);
end loop;





begin
-- Call the procedure
export_p_out1(export_start_date_in => '01-JUN-2009',
export_stop_date_in => '30-JUN-2009');
end;

ORA-22275: invalid LOB locator specified
ORA-06512: at "SYS.DBMS_LOB", line 945
ORA-06512: at "DB.EXPORT_P_OUT1", line 300
ORA-06512: at line 3