Re: PL/SQL - UTL_FILE

From: Michel Cadot <micadot_at_netcourrier.com>
Date: 2000/08/10
Message-ID: <8mto45$qdr$1_at_s1.read.news.oleane.net>#1/1


[Quoted] Sybrand Bakker <postbus_at_sybrandb.demon.nl> a écrit dans le message : 965847547.24803.0.pluto.d4ee154e_at_news.demon.nl...
> 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.

[Quoted] [Quoted] I don't try On Unix, but it doesn't work on network drive on Windows NT.

> 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
> >
> >
>

--
Have a nice day
Michel
Received on Thu Aug 10 2000 - 00:00:00 CEST

Original text of this message