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

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.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

D. Motsiff wrote in message ...


>hi All

>

>i'm trying to read and write to text files on my local box using

>UTL_FILE with no luck.

>

>i can read and write to text files out on the database (on the remote

>database box) with no problem.

>

>does anyone know if this is possible in anyway?  possible code

>snippets?      or am i just grasping at straws tring to do this with

>PL/SQL?

>

>thanks

>Dale