Re: UTL_FILE and saving on webserver

From: Alan Moor <asmoor_at_ix.netcom.com>
Date: Sat, 14 Aug 1999 18:59:20 -0400
Message-ID: <7p4t6l$rqi@dfw-ixnews19.ix.netcom.com>

Not sure, but I don't think utl_file works on mapped drives. Period. Security issue, don't you know.

Run a simple script that waits for the existence of the file and copies it where you need it. Maybe it can wake up every 60 seconds and check (cron on unix, at on NT)

Good Luck
Alan

Mike Heisz wrote in message ...
>I am trying to create a script to create an HTML file to be accessed on our
>webserver (to increase speed and limit the usage of the database). I have
>the UTL_FILE package working and creating a file in a directory on our
>database server. I run into problems when I try to place this file on the
>webserver. We have added the correct path (by mapping a network drive) for
>the webserver to the UTL_FILE_DIR parameter but when I try to create a file
>on the webserver I get the illegal_operation exception. We have tried
>opening the permissions on the webserver to make it accesible to anyone but
>that didn't help.
>
>Any help would be greatly appreciated.
>
>Thanks,
>Mike
>
>
Received on Sat Aug 14 1999 - 17:59:20 CDT