OraFAQ Forum: SQL & PL/SQL » How to call a URL and read what it returns?

Home » SQL & PL/SQL » SQL & PL/SQL » How to call a URL and read what it returns?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to call a URL and read what it returns? [message #189048]

Wed, 23 August 2006 00:26

cacheboy
Messages: 21
Registered: August 2006

Junior Member

I got a URL in varchar2, how do I go to that URL and then read it's output in another varchar2?

Report message to a moderator

Re: How to call a URL and read what it returns? [message #189072 is a reply to message #189048]

Wed, 23 August 2006 02:07

cacheboy
Messages: 21
Registered: August 2006

Junior Member

Actually, I need to do a HTTP form POST to an URL and get back the response.

Report message to a moderator

Re: How to call a URL and read what it returns? [message #189073 is a reply to message #189072]

Wed, 23 August 2006 02:12

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

You need the UTL_HTTP package.
There are examples included with that documentation.

If what you are doing is pretty simple, you maybe able to use the simple UTL_HTTP.REQUEST, otherwise you'll need to do something more complex.
AskTom has several examples too.

Report message to a moderator

Previous Topic:	Having trouble understanding EXISTS clause
Next Topic:	Some String operations..

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 17:42:35 CST 2024