How to call SOAP webservice in PL/SQL-Oracle?

[dipen_pandya]

Hi Experts,

We have XI 3.0, I have developed SOAP-XI-RFC asynchronous scenario and defined SOAP webservice.

Provided webservice URL & WSDL file to Oracle developer team, but they are not aware of how to consume webservice in Pl/SQL.

Can anyone please give hints, suggetions, links, documents regarding calling webservices in PL/SQL.

Please help, it would be highly appreciated.

Thanks in advance.

Regards,

Dipen.

[iaki_vila · Accepted solution]

Hi Dipen,

This question depends about the DB vendor, for example from ORACLE: ORACLE-BASE - UTL_DBWS - Consuming Web Services in Oracle 10g Onward

Regards.

[dipen_pandya · Accepted solution]

Hi Inaki,

Thanks for a quick responce.

I know this question is purely depends with the DB vendor & developer but at our end they are not aware of how to call webservice in PL/SQL. So somehow i want to help them if i can get any useful inputs from our SCN community members.

I will appriciate it a lot.

[dipen_pandya · Accepted solution]

Hi Inaki,

Thanks for suggesting a helpful link.

Our PL/SQL developers found that link useful.

Thanks a lot.

BR,

Dipen.

[xinjiang_li · Accepted solution]

Hi Dipen,

This is another link they can use (by using another package utl_http).

http://blog.csdn.net/yehangchuan11/article/details/8491442

Regards.

[dipen_pandya · Accepted solution]

Hi,

Thanks a lot.

BR,

Dipen.