Re: UTL_FILE on client side

In article <91bke3$klr$1_at_nnrp1.deja.com>,   Bill <wsprouse_at_my-deja.com> wrote:
> Hello all.
>
> I am trying to use the UTL_FILE package to write output to a file on a
> client computer. The client is NT 4.0, Oracle is on a Unix box and I
 am
> running the code in SQL*Plus on the client. The documentation seems
 to
> suggest I can use this package to write to files on the client - is
 this
> true?
>
> When I run the code the INVALID PATH exception is raised when I use
 the
> UTL_FILE.FOPEN. I am trying to direct the output to a directory and
> file on the NT client.
>
> Thanks in advance.
>
> Bill
>
> Sent via Deja.com
> http://www.deja.com/
>

The UTL_FILE writes only to the files specified within the server control files. For all practical purposes that means only onto the server. If you PC was mounted onto the server, I think you could write to it.

My solution was to write to a specific directory and then FTP/transfer the file over to the appropriate machine. The only other way is to have an Oracle instance on the local machine ( not a client anymore ) that accesses the data on the unix server. The local instance could obviously write onto the local machine.

--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski_at_rii.com
              Usual disclaimers


Sent via Deja.com
http://www.deja.com/