Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: problems with utl_file

Re: problems with utl_file

From: Kenneth Koenraadt <plovmand_at_hotmail.com>
Date: Sat, 11 Aug 2001 18:55:49 GMT
Message-ID: <3b757e5b.16911539@news.mobilixnet.dk>

On Sat, 11 Aug 2001 14:28:50 GMT, Andreas Streitberger <andreas.streitberger_at_cet.at> wrote:

>hi,
>I've just upgraded from oracle 8.1.6 to 8.1.7 under Win2k and am now expiriencing some troubles with calls to utl_file.
>I already made sure, I've got access to the specified directory by setting utl_file_dir=("*") in in the ini-file the database uses (initvpab1.ora).
>Still I get errors like this:
>ERROR at line 1:
>ORA-06510: PL/SQL: unhandled user-defined exception
>ORA-06512: at "SYS.UTL_FILE", line 101
>ORA-06512: at "SYS.UTL_FILE", line 157
>ORA-06512: at "VPAB.PKG_VPKONTO_VW", line 243
>ORA-06512: at "VPAB.VPKONTO_ACC", line 4
>ORA-06512: at line 1
>
>Where did I miss to change a parameter to give access to a desired directory?
>
>Any answer is welcome
>Andy
>
>

Hi Andy,

The documentation states that

UTL_FILE_DIR = * is the correct specification for allowing UTL_FILE access to ALL dirs. You have specified utl_file_dir=("*").

Also : multiple values of UTL_FILE_DIR must be on contiguous lines of the parameter file, i.e.

UTL_FILE_DIR = * 
DB_BLOCK_BUFFERS = 8192
UTL_FILE_DIR = /mydir

Will only grant access to /mydir.

Regards,
Kenneth Koenraadt
Systems Consultant
Oracle DBA
plovmand@<no-spam>hotmail.com Received on Sat Aug 11 2001 - 13:55:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US