Hello Experts, My Name is Aj currently working with APEX and Oracle DB:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
I have explored (Googling) PL/SQL to consuming webservices. Most of the samples I found (which I tried and worked) are for REST using ACL, and has parameters within the URL. I did find one for SOAP which using APEX Schema and ACL (link pasted below). However, I am striving to consume a webservice for which I was provided with various WSDL XML files like Input.xsd, inputspecificaton.xsd, output.xsd and more. I never had a chance to work in consuming a webservice using all these WSDL XML files with BASE64 encoding. Can the experts given me few sample Programs or links which emulates this approach of webservice consumption. On Java end they seem to have WSDL XML schema (as they call it) and Jackson/pojo that converts to BYTE Array. I am not sure how all this translates to PL/SQL. Kindly provider samples if any.
Thank you All.
Link for SOAP XML Sample that I tried: https://oracle-base.com/articles/misc/apex_web_service-consuming-soap-and-rest-web-services