OraFAQ Forum: SQL & PL/SQL » UTL_FILE

Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE - Invalid Path

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

UTL_FILE - Invalid Path [message #8256]

Wed, 06 August 2003 07:56

Michele
Messages: 77
Registered: December 2000

Member

Hi Everyone,

I have a stored procedure which inserts data from 1 table to another on a weekly basis. If an exception is raised then I am calling the utl_file package to write out an error text file. My problem is:I keep receiving an invalid path error.

My database is on Sun Solaris.
my init.ora file has this parameter in it:
UTL_FILE_DIR = /u01/app/oracle/product/9.0.1/utl_file
**I shutdown and restarted the database.

My code has this:
LDAT_OUTPUT := utl_file.FOPEN('/u01/app/oracle/product/9.0.1/utl_file','weeklyLDAT.txt','w');

I understand the owner of the oracle processes should have access to the directory where the text file is written and the user does.
I also issued a command:
chmod 777 on the directory above so all users can have read and write privileges.

Is there something else I am missing?

Thanks
Michele

Report message to a moderator

Re: UTL_FILE - Invalid Path [message #8257 is a reply to message #8256]

Wed, 06 August 2003 09:27

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

in 9i, use CREATE DIRECTORY statement.
UTL_FILE_DIR in INIT.ora  is dessuported.
refer docs more information

Report message to a moderator

Previous Topic:	DECODE help!
Next Topic:	function returning more ...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 01:01:45 CDT 2024