Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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