OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » Calling URL using Database without specifying a browser

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Calling URL using Database without specifying a browser (PL/SQL)

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

Calling URL using Database without specifying a browser [message #559172]

Fri, 29 June 2012 07:26

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

Littlefoot
Messages: 21807
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?

Report message to a moderator

Re: Calling URL using Database without specifying a browser [message #559175 is a reply to message #559174]

Fri, 29 June 2012 07:43

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

Report message to a moderator

Re: Calling URL using Database without specifying a browser [message #559176 is a reply to message #559175]

Fri, 29 June 2012 07:45

jolieassaad
Messages: 18
Registered: May 2012
Location: Lebanon

Junior Member

I'm using Oracle 10g

Report message to a moderator

Re: Calling URL using Database without specifying a browser [message #559179 is a reply to message #559176]

Fri, 29 June 2012 08:36

_jum
Messages: 577
Registered: February 2008

Senior Member

You find an example here in the forum.

Report message to a moderator

Re: Calling URL using Database without specifying a browser [message #559193 is a reply to message #559179]

Fri, 29 June 2012 11:22

Littlefoot
Messages: 21807
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?

Report message to a moderator

Previous Topic:	Sending Emails based on query
Next Topic:	PDF attachment from Apex application

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 14:59:46 CDT 2024