UTL_FILE.FOPEN on NT4
From: David Cox <david.cox_at_merton.gov.uk>
Date: Thu, 23 May 2002 10:46:57 +0000 (UTC)
Message-ID: <cb7b347afd620c2aed0d8fa29d5c12dd.29848_at_mygate.mailgate.org>
[Quoted] I would like to be able to test for the existence of a file on an NT4 workstation which is running reports locally. I had hoped to use UTL_FILE.FOPEN and then look for an exception.
Date: Thu, 23 May 2002 10:46:57 +0000 (UTC)
Message-ID: <cb7b347afd620c2aed0d8fa29d5c12dd.29848_at_mygate.mailgate.org>
[Quoted] I would like to be able to test for the existence of a file on an NT4 workstation which is running reports locally. I had hoped to use UTL_FILE.FOPEN and then look for an exception.
All the discussions I have seen on UTL_FILE stress the importance of setting UTL_FILE_DIR in init.ora on the server, however that clearly relates to accessing files which are on the server or are mapped on the server.
I am only interested in looking at files on the workstation. In Oracle PL/SQL Programming 2nd Ed Feuerstein and Pribyl it says (p961) "You can call UTL_FILE ... from within client-side application modules....You can, therefore interact with operating system files both on the local workstation (client) and on the server disks." Is this true?
If so, has anyone got an example of some code which accesses files on a Windows workstation.
Dave Cox
-- Posted via Mailgate.ORG Server - http://www.Mailgate.ORGReceived on Thu May 23 2002 - 12:46:57 CEST