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)

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/c...1/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/c...nt.htm#i468132

Gints Plivna
http://www.gplivna.eu

"Gints Plivna" <gints.plivna@gmail.com> wrote in message
news:1161973764.695920.186840@e3g2000cwe.googlegro ups.com...
> For getting info from internet check:
> http://download-uk.oracle.com/docs/c...1/packages.htm
> http://download-uk.oracle.com/docs/c...nt.htm#i468132

Exaxctly what I was looking for !

Thank you

Syltrem