Home » Developer & Programmer » Application Express & MOD_PLSQL » Calling URL using Database without specifying a browser (PL/SQL)
icon4.gif  Calling URL using Database without specifying a browser [message #559172] Fri, 29 June 2012 07:26 Go to next message
jolieassaad
Messages: 18
Registered: May 2012
Location: Lebanon
Junior Member
Hi ,

I want to call a specific URL from Database using PL/SQL, and I don't want to specify the browser. I used the Procedure UTL_HTTP.REQUEST but I had the following errors:
Err:ORA-12535: TNS:operation timed out
Err:ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1022
ORA-12535: TNS:operation timed out

Could anyone help me or have any other idea to solve my problem?

Regards,
Hala

[Updated on: Fri, 29 June 2012 07:29]

Report message to a moderator

Re: Calling URL using Database without specifying a browser [message #559174 is a reply to message #559172] Fri, 29 June 2012 07:38 Go to previous messageGo to next message
Littlefoot
Messages: 19510
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Browser? Where did you specify it?

Could you post code you wrote? Besides, which Oracle version do you use?
Re: Calling URL using Database without specifying a browser [message #559175 is a reply to message #559174] Fri, 29 June 2012 07:43 Go to previous messageGo to next message
jolieassaad
Messages: 18
Registered: May 2012
Location: Lebanon
Junior Member
No I didn't specify if the URL that I want should be opened using IE or Google Chrome or etc..
My code is the following:
begin
htp.htmlOpen;
htp.BodyOpen;

htp.p('Test...');

htp.p(
utl_http.request('URL')
);

htp.BodyClose;
htp.htmlClose;
end;

Thank you ,
Hala
Re: Calling URL using Database without specifying a browser [message #559176 is a reply to message #559175] Fri, 29 June 2012 07:45 Go to previous messageGo to next message
jolieassaad
Messages: 18
Registered: May 2012
Location: Lebanon
Junior Member
I'm using Oracle 10g
Re: Calling URL using Database without specifying a browser [message #559179 is a reply to message #559176] Fri, 29 June 2012 08:36 Go to previous messageGo to next message
_jum
Messages: 489
Registered: February 2008
Senior Member
You find an example here in the forum.
Re: Calling URL using Database without specifying a browser [message #559193 is a reply to message #559179] Fri, 29 June 2012 11:22 Go to previous message
Littlefoot
Messages: 19510
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
(Why did this end in the Apex forum?)

Jum thinks that it is about fetching data from some page on the Internet, right? If that's so, here's another example (which helped me a lot).

I must admit that "without specifying a browser" statement is very misleading, from my point of view. What does a browser have to do with you using UTL_HTTP? You don't want to use it, and I didn't see (anywhere in your code) that you actually use it. So what is "browser" doing here in the first place?
Previous Topic: Sending Emails based on query
Next Topic: PDF attachment from Apex application
Goto Forum:
  


Current Time: Thu Aug 28 00:58:31 CDT 2014

Total time taken to generate the page: 0.23135 seconds