Invoking a SOAP ( Web Services ) from ORACLE DB
- by Mousarules
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/">
<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/">
<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 ?
