Spooling from pl/sql procedure

From: Sunder <Sunder.nochilur_at_pcm.bosch.com>
Date: Thu, 7 Jan 1999 13:42:31 -0500
Message-ID: <772v4l$6qg$1_at_news.fr.internet.bosch.de>

[Quoted] [Quoted] I am trying to spool the output of a select statement from inside a pl/sql [Quoted] procedure to a file. See below for the code. SPOOL does not work form within [Quoted] 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:42:31 CET