Path: news.easynews.com!easynews!out.nntp.be!propagator-SanJose!news-in!newshub2.rdc1.sfba.home.com!news.home.com!news1.sttls1.wa.home.com.POSTED!not-for-mail Reply-To: "Jim Kennedy" From: "Jim Kennedy" Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.server,comp.databases.oracle.misc References: <3B9AAB2B.A0D68B6A@ix.netcom.com> Subject: Re: Can Oracle spool from a procedure??? Lines: 16 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Message-ID: Date: Sun, 09 Sep 2001 00:35:24 GMT NNTP-Posting-Host: 65.4.45.60 X-Complaints-To: abuse@home.net X-Trace: news1.sttls1.wa.home.com 999995724 65.4.45.60 (Sat, 08 Sep 2001 17:35:24 PDT) NNTP-Posting-Date: Sat, 08 Sep 2001 17:35:24 PDT Organization: Excite@Home - The Leader in Broadband http://home.com/faster Xref: easynews comp.databases.oracle.tools:44614 comp.databases.oracle.server:117615 comp.databases.oracle.misc:68496 X-Received-Date: Sat, 08 Sep 2001 18:32:52 MST (news.easynews.com) You can write to a file. look at utl_file package. See the documentation. It has a lot of sample code. Jim "Mendoza Family" wrote in message news:3B9AAB2B.A0D68B6A@ix.netcom.com... > I am running Oracle 8.1.6 and I need to spool some files. I would like > to do them from within the procedure, is it possible? If so does any one > have sample code I can use? > > I posted this message on three different Oracle groups, please send your > response to both the group and my email address. > > Thanks, > Moises