Re: UTL_FILE.FOPEN AND \\ AND $

From: Sander Goudswaard <sander_at_example.com>
Date: 18 May 2004 10:00:59 GMT
Message-ID: <Xns94ED7A3CB5D17snafuexamplecom@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 Received on Tue May 18 2004 - 05:00:59 CDT