Using UTL_FILE to read from a network drive [message #35794] |
Tue, 16 October 2001 08:03 |
Tony
Messages: 190 Registered: June 2001
|
Senior Member |
|
|
I am trying to use the UTL_FILE package to read from a shared network drive and I continue to get an invalid operation from Oracle. Can files from shared network drives be read and manipulated.
P.S I have the UTL_FILE_DIR set to *
Thanks
----------------------------------------------------------------------
|
|
|
Re: Using UTL_FILE to read from a network drive [message #35799 is a reply to message #35794] |
Tue, 16 October 2001 09:27 |
Don Thaler
Messages: 8 Registered: October 2000
|
Junior Member |
|
|
I specify a specific drivedirectory in the init.ora file i.e. utl_file_dir=c:oracle_files, and the c drive is setup as a shared drive. The actual code in the sql script is:
utl_file.fopen('C:ORACLE_FILES','NOTATION.TXT','r');
----------------------------------------------------------------------
|
|
|
Re: Using UTL_FILE to read from a network drive [message #35802 is a reply to message #35799] |
Tue, 16 October 2001 10:29 |
Tony
Messages: 190 Registered: June 2001
|
Senior Member |
|
|
This is in response to Don's email:
I need to know if this will work on a network drive, not just a file on my local machine. For instance, if I have my server mapped to another computer in my network, say drive E:, I wish to be able to read files from this drive. So far I get an invalid operation by doing this. I already know how to do this with a file on my local machine.
Thanks
----------------------------------------------------------------------
|
|
|
|