-
utl_file.fopen
For Oracle on NT, can you use utl_file.fopen to see a file on a mapped network drive?
What am I getting this:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 449
ORA-29283: invalid file operation
ORA-06512: at line 5
-
Could somebody share some hints on this?
Is "mapped network drive" viewable from utl_file package?
-
Here is the problem with UTL_FILE, mapped network drives and NT ( I belive that this is correct - at least it may point you in the right direction )
During the startup process of the machine, the services are started before any mapped drives are mounted. This will not allow the database to see the location specified by UTL_FILE_DIR ( you do have this specified in the init.ora file, right? ) during startup and will subsequentially not allow the process to write to the drive.
Now I have never had to write to a mapped drive, but I ran across this while researching. You should definately check meta-link for any specific information.
-
You cannot write to mapped devices with utl_file package.
This is local to where the DB is installed.
Secondly, have you set up utl_file_dir in your init.ora ?
Vinit
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|