How to call a Web Soap Service or API from PLSQL

Hello Everyone,

I would like to share one of my codes which allows you to call a web service (soap service) or API through PLSQL. I modified it time to time whenever something new comes up and I still do. I hope it helps you too.

 

3 thoughts on “How to call a Web Soap Service or API from PLSQL

  1. Rudi

    hallo,
    can you give me an example for call a webservice with this function ?

    • Mustafa

      Hi Rudi,

      it could be very easy based on the web service that you want to call.

      select Sf_Call_Web_Service(p_url => ‘www.myWebServiceURL.com/MyService’, p_request => ‘

      • Rudi

        thank you for your quick answer.
        but sorry, i get an error message
        select Sf_Call_Web_Service(p_url => ‘https://api.predic8.de/shop/products/’, p_request => ‘>’) from dual;
        ORA-06553: PLS-306: wrong number or type

Leave a Reply

Your email address will not be published. Required fields are marked *