Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE
UTL_FILE [message #218082] Tue, 06 February 2007 14:41 Go to next message
shivaram9
Messages: 35
Registered: August 2006
Member
Hi all,

I have a directory object created in one environment and the path looks like '/u00/dev1/test'.

there is one more subdirectory under like '/u00/dev1/test/test1'.

i want to access a file in test1 location.

when i use utl_file.fgetattr('/u00/dev1/test/test1',.....)

i get error 'ORA-29280: invalid directory path'

is there another way i could access the subdirectory using UTL_FILE package.

Thanks,
Shivaram
Re: UTL_FILE [message #218087 is a reply to message #218082] Tue, 06 February 2007 14:56 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
I believe you need to change your init.ora file to include whatever paths you want to use in UTL_FILE
Re: UTL_FILE [message #218101 is a reply to message #218082] Tue, 06 February 2007 17:59 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If you created a DIRECTORY object in the database for '/u00/dev1/test', then you should create a separate DIRECTORY object for it's subdirectory '/u00/dev1/test/test1'.

It is recommended to not use UTL_FILE_DIR.
Previous Topic: Table as variable and looping
Next Topic: Merge error. bug or not?
Goto Forum:
  


Current Time: Thu Feb 06 22:37:14 CST 2025