| UTL_FILE question [message #309555] |
Thu, 27 March 2008 19:50  |
kowalsky
Messages: 37
Registered: May 2003
|
Member |
|
|
Hi all,
I am confused by the fact that when issuing
CREATE DIRECTORY myDir AS '\\mymachine\some\path\';
with TOAD 7.4 I can see that the directory object is created.
When I try to open a file with UTL_FILE.FOPEN('myDir', 'myFile.txt', 'r') I get invalid path.
Regardless of the fact that maybe the path is invalid, or the user that tries to access the file system may not have the appropriate permissions to do just that, I thought that prior to Oracle 9i, the only way to use UTL_FILE is to modify the init.ora file and specify a value for utl_file_dir and that would be the location where I have to keep my files.
Which is it? Is it worthless to create the directory object (even though you can) for utl_file use?
Thanks,
kowalsky
|
|
|
|
|
|
|
|
| Re: UTL_FILE question [message #309560 is a reply to message #309555] |
Thu, 27 March 2008 21:30  |
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
|
Senior Member |
|
|
When Creating Directory Object Oracle does not check whether path provided is correct or not.It's your responsibility.
Ask your Network administrator to grant acccess to that directory at Operating System level.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
