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

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