Re: PL/SQL - UTL_FILE

It's true and not true.

the utl_file will run on your server (as all the pl/sql code). So any directory reachable by the server can be used, though I never tried NFS-mounted drive.
The other way around should definitely work: you make an NFS-mount of the drive designed by the DBAs for output, so you will have access to the output written on the server.
It looks like they either lack knowledge or are not very cooperative.

Hth,
Sybrand Bakker, Oracle DBA

S

"Jenny Farnham" <farnham_at_spot.Colorado.EDU> wrote in message news:8ms3jv$ct2$1_at_peabody.colorado.edu...
> Platform: Unix
>
> I have my PL/SQL code on one machine.
> The database is located on a server.
>
> I login to the database like this:
>
> sqlplus aaa/bbb_at_cfrptam
>
> I'm trying to use the UTL_FILE package,
> however, it will not work according to
> our DBA.
>
> They said because the database is on another
> machine I can not use the UTL_FILE package.
> Is that true? Is there a way around this?
>
> Thanks,
> Jennifer
> SUN Microsystems
>
>
Received on Wed Aug 09 2000 - 00:00:00 CDT