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

For outputting data to local filesystems, you could use TXT_IO if you are running a forms/reports application, though.

Jeroen van Veldhuizen.

Christian Sage wrote:

> 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 Wed Mar 28 2001 - 23:40:35 CEST