Re: UTL_FILE, first attempts at using!

Larry Jones wrote:

> Current Environment:
>
> SQL*Plus: Release 3.3.2.0.2
> Oracle7 Server Release 7.3.2.3.0
> PL/SQL Release 2.3.2.3.0
> Unix (Solaris) Server
> Windows 95 client
>
> I am wanting to write flat files to my PC workstation, using this
> utility, and now I am finding out that I got my hopes up by reading a
> paper from the recent Oracle conference. It led me to believe that I
> could do this, but my DBA locally says "nope".
>
> I assume the problem is b/c we run Oracle on a Unix box, so they can't
>
> set the required path parameter to something like "C:\TEMP", or
> whatever, since that is not valid on the Unix side of things. Can this
>
> parameter be set for the client side, or is it only a server side
> setting?
>
> I want to use PL/SQL through a SQL*PLUS window on the PC, to write
> output directly to a text file on my PC.
>
> Right now I can do it with the old temp file/spool command, but I've
> been waiting for something like this from Oracle for a long time, and
> I
> thought it was here.
>
> Does anyone know if this can be done?
>
> Thanks,

 How about making your local disk appear local to the server - by mounting it using NFS or similar..?

Steve Phelan. Received on Wed May 28 1997 - 00:00:00 CEST