Oracle-L: RE: UTL

From: Thomas Day <tday6_at_csc.com>
Date: Tue, 11 Mar 2003 12:28:45 -0800
Message-ID: <F001.00566CC9.20030311122845@fatcity.com>

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