Need to invoke a web service from pl/sql.

Feb 24, 2014 8:47AM

Hi Guys,

This is a requirement to call a web service from PL/SQL procedure .

I have created a sample procedure .. It is as below .

------------------------------------------------------------------------

Declare

http_req SYS.utl_http.req;

i number;

Begin

http_req:= SYS.utl_http.begin_request

, 'POST'

,'HTTP/1.1'

);

EXCEPTION

When Others Then

Dbms_output.put_line(sqlerrm);

End;

/

After execution of this procedure .The error throws as below

------------------------------------------------------------------------------------

ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1130
ORA-12535: TNS operation timed out

Can anybody please help me out what is the exact reason behin this ?

PL/SQL (MOSC)