Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Retrieving a value (currency conversion factor) from the Internet

Re: Retrieving a value (currency conversion factor) from the Internet

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: 27 Oct 2006 11:29:24 -0700
Message-ID: <1161973764.695920.186840@e3g2000cwe.googlegroups.com>


Syltrem wrote:
> Hi
>
> Is there any method I could use from within Oracle, to retrieve a value from
> a Internet site.
> I"m told by the programmer that the value would be in XML
>
> The Oracle server has access to the Internet.
> So I can it connect to http://something , get the XML data, and parse it ?
>
> Thanks for any pointer you may give
>
> Oracle 9iR2 on OpenVMS 7.3-1
>
> --
> Syltrem
> http://pages.infinit.net/syltrem (OpenVMS information and help, en français)

For getting info from internet check:
http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14261/packages.htm About the UTL_HTTP Package
Package UTL_HTTP allows your PL/SQL programs to make hypertext transfer protocol (HTTP) callouts. It can retrieve data from the Internet or call Oracle Web Server cartridges. The package has two entry points, each of which accepts a URL (uniform resource locator) string, contacts the specified site, and returns the requested data, which is usually in hypertext markup language (HTML) format.

For XML you can start in
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14220/content.htm#i468132

Gints Plivna
http://www.gplivna.eu Received on Fri Oct 27 2006 - 13:29:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US