Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: UTL_FILE
He needs to make his Windows C: drive into a network mounted drive on the HP box.
I remember back in a mixed AIX/WinNT environment I was able to mount a CD-ROM drive on the AIX box as a network drive on the WinNT box. I don't know if it's possible to do it the other way round, especially in an HP/Windows environment.
If it can be done, that's what you need to do. Then define the path as the HP server would see it, not as your Windows client would see it.
"Mercadante, Thomas F" To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> <NDATFM cc: @labor.state.ny. Subject: RE: UTL_FILE us> Sent by: root 03/11/2003 02:53 PM Please respond to ORACLE-L
Eric
Utl_file only write to the database server. You can use Dbms_Output and spool the results to the local machine. Or 'select' the data to be spooled out.
Hope this helps!
Tom Mercadante
Oracle Certified Professional
-----Original Message----- From: Harrington, Eric [mailto:Eric.Harrington_at_maine.gov] Sent: Tuesday, March 11, 2003 2:30 PM To: Multiple recipients of list ORACLE-L Subject: UTL_FILE Any help would be appreciated... Is it possible to write a file to the local OS if the database is remote? Should I be using UTL_FILE or another package? I'm attempting to write to a file on my local OS (Windows NT 4.0). The database version is 9i r2 and resides on a HP-UX box. I've created a directory object as follows: CREATE OR REPLACE DIRECTORY utl_file_dir AS 'c:\'; The output from the SQL statement: select * from all_directories; follows: OWNER DIRECTORY_NAME DIRECTORY_PATH ------------- ------------------------------ ---------------------------- SYS UTL_FILE_DIR c:\ File handle code from my procedure follows: l_FileHandle := UTL_FILE.FOPEN('UTL_FILE_DIR','role.txt','r'); When executing the associated procedure I get the following error: ORA-29280: invalid directory path Thanks, Eric Harrington
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thomas Day
INET: tday6_at_csc.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Mar 11 2003 - 14:28:45 CST
![]() |
![]() |