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

On Thu, 16 Jun 2005 14:37:56 -0700, belda2010 interested us by writing:

> Thanks Hans for your clarification of the problem.
>

Several possibilities are still available:

1. Use Windows file 'sharing' to make the files visible on the machine running the Oracle server;
2. Use HTTP to upload the files;
3. Use Oracle's "Oracle Files" portion of the Oracle Collaboration Suite;
4. You say 'no FTP available'. Does that mean 'none at all permitted' or 'not from the Oracle machine'? You could implement a PL/SQL-based FTP using UTL_TCP ... Oracle's Service Delivery Platform has done exactly that;
5. Transfer the file using message queue technology - MSMQ <--> Oracle AQ
6. Some other .net, odbc, ado solution

As it stands, there is still insufficient information about the objective here, and (as a result) we are making the assumption that the file must be transferred.

A discussion based on the business purpose, rather than the technology, might provide a better list of alternatives.

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