Re: Writing to a text file from PL/SQL

Jasna Prester escribió:
>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);

BEGIN
>f:='hello';
>dbms_output.put_line(f);
>spool off; ----------------->you don´t need the spool off;
>end;

If this doesn´t work, try adding

dbms_output.enable(); at the beginning

-- 
Atte.
Álvaro Palma Aste
Grupo de Ing. Biomédica
Depto. de Ing. Eléctrica - U. de Chile
******************************************************
It's the only form of protest they're allowed 
I've seen their silent faces scream so loud 
If they were to speak these words they'd go missing too 
Another woman on a torture table what else can they do

Sting - They Dance Alone...