Re: Spooling from pl/sql procedure

Maybe take a look at your oracle manual (just look for the utl_file package)

Sunder wrote in message <772v4l$6qg$1_at_news.fr.internet.bosch.de>...
>I am trying to spool the output of a select statement from inside a pl/sql
>procedure to a file. See below for the code. SPOOL does not work form
within
>a procedure.Can anybody tell me how I can accomplish this.
>
>
>declare
>mailid varchar2(100);
>cursor c1 is select name from table1;
>begin
> for orec in c1 loop
> spool file1.lis
> select * from table2 where name = orec.name;
> end loop;
>end;
>
>
>
Received on Thu Jan 07 1999 - 19:58:17 CET