Re: UTL_FILE Package

in $ORACLE_HOME/dbs/initfoo.ora (where "foo" is your SID):

utl_file_dir = /tmp /usr/tmp

Shutdown and startup your database.

To check:

SQL> select name, value from v$parameter where name = 'utl_file_dir';

NAME VALUE

------------------------------ ------------------------------
utl_file_dir		       /tmp, /usr/tmp

SQL> declare f01 utl_file.file_type; begin f01 := utl_file.fopen('/usr/tmp', 'foo', 'w'); end;   2 /

PL/SQL procedure successfully completed.

SQL> Oracle will cut off anything after...256? characters in utl_file_dir, so don't go crazy.

Philippe Dansereau wrote:
>
> Hello,
>
> I'm trying to use the UTL_File package to create a bunch of batch files
> for SQL*Loader. Feurstein's book on PL/SQL says that accessible directories
> must be defined in the init.ora for the instance. Alas it does not define
> the format of those entries. Is there a PL/SQL guru in this news group?
>
> Thanks in advance
Received on Sat Dec 05 1998 - 04:04:50 CET