Re: problems with utl_file

Am Sat, 11 Aug 2001 18:55:49 GMT, hat plovmand_at_hotmail.com (Kenneth Koenraadt) geschrieben:
> 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

I tried this syntax as well as the one you mentioned, both will show up in the startup-parameters of the instance as '*' (without quotes). I restarted the instamces after changing the parameters, but it would change the behaviour.

Thank you for your immediate help
Andy Received on Sun Aug 12 2001 - 08:50:45 CDT