Call WS from stored procedure (Oracle)

[Former Member]

Hi All

I have scenario: JDBC - XI - RFC. It works fine.

Now I want to change it to SOAP - XI - RFC.

I can take wsdl url in Sender Agreement.

I can test it from Web Services Navigator - it is ok.

Can I send message from Oracle using soap_api? Give me a sample plz

Regards,

Andrey.

[Former Member]

I don`t want to write an EJB and create a Web service. I have a chanell - Sender with adapter type SOAP. In sender agreement I see WSDL. And I want to send message from Oracle (using soap_api) to this chanell.

[Former Member]

And can I send SOAP message to XI without publishing web service?

[jyothi_anagani]

Hi,

Write an EJB and create a Web service on that then you will get WSDL there. Now you can do the SOAP-XI-RFC.

Thanks.

[Former Member]

Oracle9i allows direct access to web services from PL/SQL using the UTL_HTTP package.

[former_member181985]

you need a custom application which can read DB and send the data to XI through exposed webservice.

The custom application can be implemented in any language such as JAVA, C/C++, NET etc..........