Re: Writing to a text file from PL/SQL

From: Tim Cross <tcross_at_nospam.une.edu.au>
Date: 24 Jul 2002 09:15:12 +1000
Message-ID: <87n0si6npb.fsf@blind-bat.une.edu.au>

"Jasna Prester" <jasna.prester_at_viadukt.tel.hr> writes:

> 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;
>

Try -

set serveroutput on size 100000
spool c:\temp\via2.txt

declare

f varchar2(30);
begin

f:='hello';
dbms_output.put_line(f);
end;
/

spool off

Tim Received on Tue Jul 23 2002 - 18:15:12 CDT