Re: connect databases via http
Date: Fri, 1 Feb 2008 10:23:00 -0800 (PST)
On febr. 1, 17:37, "shakespeare" <what..._at_xs4all.nl> wrote:
> "Donkey Hot" <s..._at_plc.is-a-geek.com> schreef in berichtnews:Xns9A37B6015C393SH15SGybs1ysmajw54s5_at_18.104.22.168...
> > "shakespeare" <what..._at_xs4all.nl> wrote in
> >> "Ana C. Dent" <anaced..._at_hotmail.com> schreef in bericht
> >>> prunoki <hegyv..._at_ardents.hu> wrote in news:f8c01d18-c872-4a00-9fa6-
> >>> 33e7491f4..._at_e25g2000prg.googlegroups.com:
> >>>> Hi,
> >>>> Do you know of any means to connect two Oracle 10g databases via
> >>>> http or https without using a middle tier (php, java, whatever...)?
> >>>> One db here, one db there and the traffic have to go through company
> >>>> firewalls. No proxys would be standing in the way, we get direct
> >>>> connectivity via http. It would be very nice to be able to query the
> >>>> other database somehow directly from pl-sql.
> >>>> Regards,
> >>>> Krisztian
> >>> Oracle RDBMS does not speak hhtp or https.
> >>> So the short answer is, "NO!".
> >> This is not completely true, the oracle listener can also accept http
> >> requests, and listen to port 80. A database can be contacted through
> >> http without having a http server.
> >> If the above functionality can be built with that... I doubt it. One
> >> could perform procedure/function calls over http...
> >> Shakespeare
> > I doubt the Oracle listener can "Talk" http, while certainly can be
> > configured to use http port (80) instead of the default.
> > But anyway, if the corporation needs this, it certainly can open Oracle
> > default port in it's firewalls. Which is dangerous.
> > No matter what the port is, it's dangerous. I would not open my Oracle
> > server to the internet, no matter how "unbreakable" is might be in Larry
> > Ellison's head.
> I guess your right, listening is not talking....
I have found something:
One can use utl_http on the querying side (try select utl_http.request ('http://www.google.com') from dual, if I can recall it correctly). The other side can be an Apache using mod_plsql to call pl/sql procedures to generate the answer. In my case the answer can be an XML, which the querying side can process easily. As far as I can see it could be done this way, more or less like a web service.
Krisztian Received on Fri Feb 01 2008 - 12:23:00 CST