Re: UTL_FILE -- accessing network drives under NT question

A suggestion I would give to solve this problem is to use a 'daemon' process on the NT box using C and ProC/OCI. Wrap your UTL_FILE calls in a procedure or package and have your Oracle session talk to the daemon process via dbms_pipe. The daemon process can map any drives it needs prior to calling the package. Then the path should be accessable.

note: you might want to create the daemon as a NT service (like the listener)

this might be too much work for what you want to do, but I am sure it would work.

Phil Bolduc
Online Business Systems
Calgary, Alberta Canada
403.265.8515

In article <szzZ.16$bB6.1463097_at_news.ipass.net>,   "David Sisk" <davesisk_at_ipass.net> wrote:
>
> Hi:
>
> I tried the same thing recently. Oracle Support said "no, it has to be a
> local drive". I also tried mapping a drive. The problem here is (I
> believe) that the drive mapping is only *visible* to the user who mapped it
> (not SYSTEM, which is what the Oracle process runs under). Also, when you
> sign off from the console, the drive mapping is disconnected until you sign
> in again (assuming you clicked the "reconnect" checkbox).
>
> If you find a way to do this on NT, email me and let me know!
>
> Regards,
> Dave
>
> John Nelson wrote in message <35338f1a.600699750_at_news.alterdial.uu.net>...
> >Is it possible to write to a network drive under NT using the UTL_FILE
> >package?? I have tried both full network path syntax
> >('\\machine_name\share\directory_structure') and mapping the network
> >drive to a drive letter on the Oracle server. Any help would be
> >appreciated as this functionality is required by a program we are
> >writing.
> >
> >Thanks,
> >John
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Apr 17 1998 - 20:32:36 CDT