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

use UTL_FILE package to output to text file. There is no way to output to binary for the time being.

John

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.
Received on Thu Sep 02 1999 - 22:07:27 CDT