Re: How to Read Files Located Outside the Oracle Server Using PL/SQL

On Thu, 16 Jun 2005 13:49:42 -0700, belda2010 interested us by writing:

> I want to read files from a directory located outside the Oracle

Let me paraphrase - check if this is a correct problem statement:

1. Oracle database (some arbitrary version) exists on computer 1 (also some arbitrary operating system and version)
2. File exists on computer 2 (possibly ome other operating system and version)
3. There is no direct connection between server 1 and server 2, such as disk sharing, NFS, remote mount, etc. This is an assumption, implied as you had not stated anything to the contrary.
4. You wish to read the file in computer 2 using Oracle's utilities on computer 1

If true, there are a few possible solutions but they heavily depend on whether you are going to permit intermediate operations, such as an upload, and/or the operating systems and available capabilities.

(My first visual on this was: you want to have a glass of water. You are in one room. The glass of water is in another. You are not permitted to leave the room you are in.)

I suspect there is additional information you could provide, based on the above.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***