Re: read and write to textfiles on "local" box with PL/SQL?

.

i am actually trying to set up a series of SQL reports and PVCS tools for coworkers to run by themselves. In order to save my fellow cubemates from the 'ordeal" of having to copy the files from the remote database to their local drives after running every report, i wanted to save them directly to the local drives for them. ( i know, i know, what's so hard about a 'cp' command, right? <grin>)

but i don't think its possible to do this without confguring the 'init.ora' file to mount the local drives as someone has mentioned. ( i don't have permissions to do this, and if i did, it would surely not make my DBA too happy.)

not too many other options, are there? maybe i could kick off a ftp script from a pl/sql procedure? is this possible from inside a pl/sql block?

thanks for the responses, btw.

On Wed, 26 Sep 2001 21:39:29 +0100, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>
>utl_file is run by the server-side executable,
>and is designed to read and write only on
>server-side directories (as specified in the
>utl_file_dir in the init.ora).
>
>Would it be appropriate to tell the server
>to mount your disks so that they appear
>to be local to the server ? This might
>fool Oracle.
Received on Wed Sep 26 2001 - 23:48:33 CDT