Re: Java stored proc accessing network mapped drives

I had the same problem in the past when trying to read BLOB files (using DBMS_LOB) from a mapped drive or using UTL_FILE to read/write from a mapped drive. Its because the 'pseudo' user who runs the Oracle service does not know anything (and cannot easily know anything) about mapped drives.

2 ways you can solve this.

• Run the Oracle service under a OS user who can see the mapped drives and WHO IS LOGGED INTO THE SERVER whilst Oracle is running.
• Use the UNC directory method to access the file (e.g \\machine\share\directory\file).

They both worked for me, the latter is probably more feasible since you dont always want an OS user logged in when running Oracle on a server.

A search on Metalink should reiterate what I said in detail.

HTH, let us know how you get on.

Mark

samson_at_ozemail.com.au (Lyndon) wrote in message news:<14def24b.0204221547.2a1fd74c_at_posting.google.com>...
> Hi
>
> I have a problem where a JSP ( Java stored procedure ) running on
> Win2k is trying to write to a network mapped drive. I have granted the
> correct java perms with dbms_java calls but it appears that the
> network drive is not accessable to oracle. When writing to a local
> drive everything works as expected.
>
> I've tried running the Oracle service as both INTERNAL and a real user
> but it has no effect.
>
> Oracle version is 8.1.7
>
> I've also 'execd' "net use" and it reports that the mapped drive is
> 'unavailable'.
>
> What goes on here?
Received on Tue Apr 23 2002 - 03:01:37 CDT