Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: pl/sql output to file
When you specify the name of the output file, prefix it with a full path to the desired location and your file will appear there as if by magic. This is a great utility.
OIT <104155.2074_at_compuserve.com> wrote in article
<01bc9b5d$6a8b2920$af5e6580_at_j553fac.UMN.EDU>...
> I need to be able to create a flat file and place it in a designated
place
> on the network. Since spool will only work with sql*plus is my only
option
> the UTL_FILE package? If so how flexible is ability to place the output
> anywhere on the network? we're running Oracle 7.3. Any hints or
> suggestions will be greatly appreciated!
>
> Doug Swanson
>
Received on Tue Jul 29 1997 - 00:00:00 CDT