calling external webservice from oracle pl/sql stored procedure
632959Feb 22 2009 — edited Feb 23 2009Is there anybody who has successfully accessed a SOAP Web service from an Oracle stored procedure?
here is my WSDL: "http://api.mediadns.com/orabpel/mdnsprivate/SPSendNotification/1.0/SPSendNotification?wsdl"
The above wsdl will send the email notifications based on the requirement. Now I need to invoke the wsdl provided above from Oracle 10g pl/sql stored procedure.
Please provide me the sample code,If anybody who has successfully wrote pl/sql stored proc to invoke the wsdl. Its my humble request and i need it very urgent.
Cheers,
Nuthan.