Home » SQL & PL/SQL » SQL & PL/SQL » How to call a URL and read what it returns?
How to call a URL and read what it returns? [message #189048] Wed, 23 August 2006 00:26 Go to next message
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?
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 Go to previous messageGo to next message
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.
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 Go to previous message
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.
Previous Topic: Having trouble understanding EXISTS clause
Next Topic: Some String operations..
Goto Forum:
  


Current Time: Wed Dec 07 10:49:14 CST 2016

Total time taken to generate the page: 0.10168 seconds