Re: Is there a way I can direct a output of select statement (in a stored procedure) into a file?

Home -> Community -> Usenet -> c.d.o.server -> Re: Is there a way I can direct a output of select statement (in a stored procedure) into a file?

From: <buzkoff_at_my-deja.com>
Date: Fri, 03 Sep 1999 03:17:25 GMT
Message-ID: <7qnejt$jp5$1@nnrp1.deja.com>

In Oracle 7.3.x use the UTL_FILE package, it contains all the necessary functions. In earlier versions, use DBMS_PIPE, but you will need a receiver in the OS to store the pipe contents onto a file. I was using a PRO*C daemon to do it.

In article <7qn1pm$b6j$1_at_nnrp1.deja.com>, pcmwong_at_my-deja.com wrote:
> Hi All,
>
> Is there a way I can direct a output of select statement (in a stored
> procedure) into a file?
>
> I know I can use spool command to direct the output into a file under
> SQL Plus or SQL Plus Worksheet.
>
> How about in a stored procedure of a database?
>
> Please help.
>
> Thanks a lot for your input.
>
> Yours Truly,
>
> Paul
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Sep 02 1999 - 22:17:25 CDT