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 <[EMAIL PROTECTED]>
<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:[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
