Logging dbms_output.put_line to file

[ales]

set echo off
set feedback off
set verify off
set heading off
set serveroutput on size 65536
spool test.txt
begin
dbms_output.put_line('hello');
end;
/
spool off

now do cat test.txt
... if you're on unix. If you're on Win use notepad or your favourite text editor.



[Edited by ales on 04-29-2002 at 07:11 AM]