Re: [UTL_FILE]Can we use it under Windows 95/98/ME

Hi Patrick,

the UTL_FILE package is part of the PL/SQL packages delivered with and built into the Oracle Server. It deals with output to and input from files local to the database server only.

That means files will always be written on the machine where the database is running. If you are using Personal Oracle on your 95/98/ME box, files will end up there. If, on the other hand, you are using an Oracle client connected to a remote server, files will end up on the remote machine (or have to be there in order for UTL_FILE to be able to read them).

To circumvent this limitation you could think about working with remotely mounted file systems. For a variety of reasons (could require additional software, is a potential security breach, generates administrative overhead, etc.) I don't think that is such a good idea, though.

Generally you should read and write things through the client if your data source or sink is on the client machine, and you should use UTL_FILE when you need to do things directly on the server machine.

Hth,
Christian Sage

"Patrick Lo" <cylo_at_vtc.edu.hk> schrieb im Newsbeitrag news:3AB95966.6CFF465F_at_vtc.edu.hk...
> Hi Sascha,
>
> Thanks for your information. Do you mean that if I use the function under
 the
> UTL_FILE package in the SQLPLUS on my PC, the file read/write will be
 accessed
> on the Oracle Server platform, say Sun Solaris Unix ?
>
> Thanks.
>
> Sascha Schlangenotto wrote:
>
> > Hi Patrick,
> >
> > yes, you can use the UTL_FILE Package to read/write files on Windows
> > 95/98/ME
> > platforms. You just have to remember that you can only read or write
 files
> > on the
> > Oracle Server, not on the client.
> >
> > Sincerely
> > Sascha Schlangenotto
> >
> > Patrick Lo <cylo_at_vtc.edu.hk> schrieb in im Newsbeitrag:
> > 3AB5AD53.A0D6CCBC_at_vtc.edu.hk...
> > > Hi,
> > >
> > > Would anyone tell me whether we could use the functions of the package
> > > UTL_FILE under Windows 95/98/ME such that we can directly input/output
> > > from/to files on Windows 95/98/ME platform?
> > >
> > > Thanks.
> > >
> > > --
> > > Patrick Lo
> > >
> > >
>
> --
> Patrick Lo
>
>
Received on Fri Mar 23 2001 - 06:00:11 CST