Re: UTL_FILE, first attempts at using!

Sorry to disapoint you, but your DBA is right. What are you trying to do can't be done.

The problem is not in your UNIX/PC enviroment. The problem is, UTL_FILE is server side package which can read/write only files on server side. Even if it were NT server with init UTL_FILE_PATH set to C:\TEMP it would still read/write files only from its own C:\TEMP, not from your client's C:\TEMP directory.

For your purposes, you will still be forced to use DBMS_OUTPUT within PL/SQL and spool it out from your SQL*Plus session.

Regards,

Jurij Modic				Republic of Slovenia
tel: +386 61 178 55 14			Ministry of Finance
fax: +386 61  21 45 84			Zupanciceva 3
e-mail: jurij.modic_at_mf.sigov.mail.si	Ljubljana 1000

On Tue, 27 May 1997 14:15:23 -0500, Larry Jones <lljo_at_chevron.com> 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?
Received on Tue May 27 1997 - 00:00:00 CEST