Invoking a SOAP ( Web Services ) from ORACLE DB

Question

Dears,

Kindly note that I’m trying to invoke a SOAP (web services) from ORACLE DB using pl\sql , after I have done some investigations it says that I have to use the UTL_HTTP package but It didn't work with me !!!

Kindly to advice me , where should I exactly place the following SOAP in pl\SQL to be invoked .... is it posible ?

SOAP 1.1

The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values.

POST /gmgwebservice/service.asmx HTTP/1.1

Host: bulk.umniah.com

Content-Type: text/xml; charset=utf-8

Content-Length: length

SOAPAction: "http://tempuri.org/SendSMS"

<SendSMS xmlns="http://tempuri.org/"&gt;

  <UserName>string</UserName>

  <Password>string</Password>

  <MessageBody>string</MessageBody>

  <Sender>string</Sender>

  <Destination>string</Destination>

</SendSMS>

HTTP/1.1 200 OK

Content-Type: text/xml; charset=utf-8

Content-Length: length

<SendSMSResponse xmlns="http://tempuri.org/"&gt;

  <SendSMSResult>string</SendSMSResult>

</SendSMSResponse>

--This web services refers to a web site called Bulk Messaging ; the web site sends SMS to a specific mobile number by filling in some text boxes , I need it to be done from ORACLE forms when a specific action occurs ( JOB ) but I don’t know how to use it inside my pl\sql code .

Hope that it’s clear ,is there something else I have to mention ?

Answer 1

try checking out Calling a SOAP web service from PL/SQL by extending the FLEX_WS_API