Re: Writing to a text file from PL/SQL

Please help me out one more time,
I wrote this sql procedure:

set serveroutput on size 100000
spool c:\temp\via2.txt
declare
f varchar2(30);
f:='hello';
dbms_output.put_line(f);
spool off;
end;

The file gets created but it stays empty - what am I doing wrong?

Thanks very much for help in advence,
Jasna Prester Received on Tue Jul 23 2002 - 08:46:14 CDT