Re: UTL_FILE.FOPEN AND \\ AND $

Sander Goudswaard <sander_at_example.com> wrote in message news:<Xns94ED7A3CB5D17snafuexamplecom_at_127.0.0.1>...
> avanrossem_at_hotmail.com (Andre or Anneke?) wrote in
> news:4d32d1be.0405172144.26716839_at_posting.google.com:
>
> > I have the following line of code in a package:
> > v_output_file :=
> > UTL_FILE.FOPEN('\\serv1\TestDir$\files','Testfile.txt','W');
> >
> > I also have the \\serv1\TestDir$\files in the init.ora file staan
> > (oracle 8.1.7)
> >
> > But I still have 'INVALID PATH' when opening the file.
> > with 'normal paths' (such as c:\test" it is working.
>
> You will have to let the Oracle service run under a user with access to the
> network drive, not under LocalSystem.
>
> Sander

This is usually considered as a security breach. A much simpler solution would be (space constraints provided) to dump the files locally and share the directory where the files end up.

Sybrand Bakker
Senior Oracle DBA Received on Tue May 18 2004 - 09:23:28 CDT