I am trying to create a Package that will encapsulate all the required parts to successfully call a Web service.
I already have the 'wsdl' HTTP site and it works 100% via a HTML call.
What I want to access the web service via the a PL/SQL call. That is I want to connect to the database (for example scott@myserver) and at the SQL prompt execute my_web_service_call.fetch_data('My text') and return the data from the web service.
My database consists of:
Oracle9i Enterprise Edition Release 22.214.171.124.0 - 64bit Production
With the OLAP and Oracle Data Mining options
JServer Release 126.96.36.199.0 - Production
I have done nothing to special with the database or schema that I want to use this from.
I have looked around a fair amount but have not found a full encapsulated package that I could just replace the web service html call with the web service URL I have for use on the Oracle 9 database.
Full step by step details of how to implement this would be the best.