Re: Using UTL

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 13 Aug 2001 11:34:10 +0100
Message-ID: <997698672.14918.0.nnrp-01.9e984b29@news.demon.co.uk>

The most important point to bear in mind if you do follow this advice is that anyone allowed to use the utl_file package is then able to destroy the database.

If by 'local' you mean you want the PL/SQL to run on the server, but the file to appear on the client machine, then you can't do it through simple coding methods. Remember that the PL/SQL is running on the server under the server's Oracle account, and using utl_file may only write to directories that appear to be on the server and writable by the Oracle account, and are listed in utl_file_dir.

--
Jonathan Lewis

Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html




Christof Kaiser wrote in message
<3B77A421.71DF40E7_at_logiball.deREMOVETHIS>...


>

>

>carlog wrote:

>

>> hi all,

>> only a little question, is possibile write an output file from PL/SQL and

>> save data into a local directory, but i don't want use the path stored in

>> 'utl_file_dir' parameter.

>

>dont know if it helps, but you could set 'utl_file_dir' to '*' and be free

>where to put your output files.

>

>christof

>

Received on Mon Aug 13 2001 - 05:34:10 CDT

Re: Using UTL_FILE