CALL WEBSERVICE FROM PLSQL. ORACLE 11G

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

CALL WEBSERVICE FROM PLSQL. ORACLE 11G

Postby charlibraun » Tue Apr 30, 2013 3:17 pm

Hello, i have a problem

i try to test this code:
http://www.oracle-base.com/articles/9i/ ... ces-9i.php


i implement sopa_api.sql and add_numbers function without modifications

But when i execute

SELECT add_numbers(1, 5) FROM dual;

i have errors:

ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP",line 1029
ORA-12541: TNS:no listener
ORA-06512: at "dbtest.SOAP_API",line 144

Do I need to configure something?

My database version is 11g
charlibraun
Member
 
Posts: 11
Joined: Tue Apr 30, 2013 3:11 pm

Re: CALL WEBSERVICE FROM PLSQL. ORACLE 11G

Postby Tim... » Tue Apr 30, 2013 4:08 pm

Hi.

As I said in my reply in the comments, my first guess would be your database is not able to make direct connections to the internet. Can you test this from the console?

I've just run through the example again and it definitely works for me.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17952
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: CALL WEBSERVICE FROM PLSQL. ORACLE 11G

Postby charlibraun » Thu May 02, 2013 7:58 am

ok, thank you :D but how i solve it ???
how i can able to make direct connections to the internet
charlibraun
Member
 
Posts: 11
Joined: Tue Apr 30, 2013 3:11 pm

Re: CALL WEBSERVICE FROM PLSQL. ORACLE 11G

Postby Tim... » Thu May 02, 2013 8:24 am

Hi.

I know nothing about your company or the security you have in place, so I can't really comment on what has to be done from a network or firewall perspective. You best ask the relevant people in your company.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17952
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle SQL and PL/SQL Development

Who is online

Users browsing this forum: No registered users and 0 guests