Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calling a web service from within PLSQL

shimon_bAug 18 2008 — edited Aug 21 2008
Hello !
I am trying to activate a web service located on a remote machine inside a database trigger . This WSDL has been generated by a XI (SAP) tool and located on the server on which the XI is installed.
XI is an EAI tool a product that is included in the SAP products - for integrating between SAP and other tools - including Oracle DB.
When I try to call the web service using UTL_HTTP package - a procedure i wrote correctly - I get the following error message :
"
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1029
ORA-12545: Connect failed because target host or object does not exist
"
I have GOOGLED the last message ( ORA-12545) , but the forums referred to a client for ORACLE, which is configured incorrectly; none of them referred to my case - calling a web service. BTW I tried using the web server's IP address instead of the DNS but got the same error.

Any suggestion would be very appreciated.

Best Regards,
Shimon B.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 18 2008
Added on Aug 18 2008
5 comments
4,104 views