Re: HPPT/FTP from server

Michael Will de Laforcade wrote:
>
> Hi,
>
> I noticed there is an http package that comes bundled with Oracle8. Is there
> an ftp package available.
> Also is there a way for pl/sql to communicate to another server's port
> directly, so that I can write my own FTP package??
>
> Thanks for any info....Michael.
the http package htp.XXX is part of the webserver setup. the way it works is pretty much identical to the dbmsoutput package. the oraweb process connects via sqlnet to the rdbms, calls procedures that call these htp. packages, these generate output to a buffer, and at the end of the call, the buffer is put to stdout, which in its turn is sent back to the webserver.

look into external procedures to do something like ftp package, I am not sure what you want to do, but if it is for small amounts of data or what not what you could do is write a c lib which does its own socket stuff (like ftpclient), then returns this via external functions to the plsql code you use in the database. This would work... or use this in combination with utl_file to read files from the local filesystem. eg write an external procedure that does the ftp, and then use plsql to read the file in.. makes sense ?

cheers
Wim Received on Wed Jan 14 1998 - 00:00:00 CST