Question:

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

Answer:

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

John