Re: utl_file

You must set the UTL_FILE_DIR=(path that you want to give access to) in the init@@@.ora file which should be in the ORACLE_HOME/dbs directory. It does support * so if you put an * at the end of a path statment you can read and write to all files in that directory that you have rights to. Check the programmers Guide Chapter 8 I beleive for more Info

On 9 Jul 1997 06:12:33 GMT, brianbom_at_mail.pacifier.com (HornDog) wrote:

>I was trying the canned oracle package utl_file today and trying to open
>and read a ascii file on a Sun Solaris system. I wrote some code that
>looked something like follows and I keep getting an invalid_path
>exception. Any suggestions would be appreciated!
>
>DECLARE
> filehandle utl_file.file_type;
>BEGIN
> filehandle := utl_file.fopen ('/export/post', 'test.file', 'r');
>EXCEPTION
> WHEN utl_file.invalid_path THEN
> dbms_output.put_line ('invalid_path');
> WHEN utl_file.invalid_mode THEN
> dbms_output.put_line ('invalid_mode');
> WHEN utl_file.invalid_operation THEN
> dbms_output.put_line ('invalid_operation');
>END;
>
>I looked at the obvious, the input file IS there???
>
>--
>-------------------------------------------------------
>Pacifier Online Data Service Dialup SLIP/PPP User
>To register: (360) 693-0325 or telnet pods.pacifier.com
>-------------------------------------------------------
>
Received on Wed Jul 09 1997 - 00:00:00 CDT