Re: PL/SQL - UTL_FILE

[Quoted] It's true and not true.

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

Hth,
[Quoted] Sybrand Bakker, Oracle DBA

S

"Jenny Farnham" <farnham_at_spot.Colorado.EDU> wrote in message [Quoted] 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 CEST