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

On Thu, 16 Jun 2005 15:35:35 -0700, belda2010 interested us by writing:

> Note that I should use a pl/sql procedure so I have no chance to
> develop an application outside the Oracle database server.
>
> My comments to your suggestions:
> 2- How I can use HTTP to upload a file from another server using
> pl/sql?
> 4- FTP is not available at the remote server.
>

Again it seems that someone has decided a technology and is assigning you to implemet the solution. (Almost like a typical classroom assignment.) I generally consider that silly as it rarely provides the optimal solution - a 'cart before the horse' situation that is the joy and bane of modern programming technique.

However, now I get the impression the solution:

1. must be originated by the Oracle server ;
2. is to have no human intervention.

So a few additional questions:

1. Is it possible to upgrade Oracle to something supported? (Oracle9i or 10g)
2. Why the fixation on using PL/SQL?
3. How familiar are you with TCP protocols? Could you program in UTL_TCP? (Eg: telnet?)
4. Does the other server have a HTTP service? Could the non-Oracle server be configured to deliver the files on demand using HTTP or some other service? Could it be delivered by an automated email?

(At this time, never mind about how to make the request from Oracle. There are a number of ways, including using PL/SQL and perhaps external procedures.)

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