init.ora - UTL_FILE_DIR

Hi,

I have a problem while writing to a file using utl_file.

utl_file_dir=/var/tmp,/abc/test,/DB/tests

Documentation recommends to specify each directory in single line. I have changed it to

utl_file_dir=/var/tmp,
utl_file_dir=/abc/test
utl_file_dir=/DB/tests

And have bounced the DB. Still I get INVALID_PATH exception.

Will the comma in the first line err out?

Any help will be appreciated.

Cheers,
Nandu

Note that all users can read or write all files specified in the UTL_FILE_DIR parameter(s).

No need for comma's

http://lbdwww.epfl.ch/f/teaching/cou...0/ch1.htm#7036

Thanks Suresh. That is the expected behaviour.

But my worry is, it is throwing an exception INVALID_PATH.

I have a question !

If the first path mentioned in the UTL_FILE_DIR is invalid and the consequtive paths are valid, what will happen?

Pls. note that, for this database I don't have access to V$ views to check the values.

Cheers,
Nandu

find a dba/user that can access v$parameter

issue the command

show parameters utl;

This will tell you values for parameters starting with utl.

figure it out from there.

Good Luck

Thanks Sureshy!

It's a shame ... I can't access the V$ views..

Its not the DB I maintain... and it is just to help my team, as the DBA is not around.

Anybody else, have ever been stuck up with INVALID_PATH?

Help Please !

Cheers,
Nandu

Don't take this wrong, but are you sure the paths exist? Correct spelling? (You said it wasn't your database - maybe you were given some wrong info about directory locations.)

Don't take this wrong, but are you sure the paths exist?

Thats a very valid point u have made.

I have checked with the path. Case sensitivity... etc.,

Everything is fine.

I still wonder if something is wrong with the Parameter setting itself... pls. see msg., above for how it looks like.

Cheers,
Nandu

Okay, who owns the directories? Should be oracle.

NANDU:

According to Oracle "The directories that UTL_FILE can read from and write to need to have permissions of the Oracle instance owner and the user running the package."

Run chmod 777 directory_name at the unix prompt and this might help.

Something else:

utl_file_dir=/var/tmp, utl_file_dir=/abc/test, utl_file_dir=/DB/tests

should be enough for the init.ora