Did someone achieve this? Usually we use SOAP_API to hit SOAP services http://www.oracle-base.com/dba/miscellaneous/soap_api.sql But we do not know how to access SOAP/REST services on the Service Locator with pl/sql. According to documentation we should add a library in the consumer, which works for java projects, but how to proceed from ps/sql? Thanks
SL SOAP services will expose 4 operations at http://localhost:8040/services/ServiceLocatorService?wsdl which can be used to register/lookup endpoints from SL. 1. registerEndpoint 2. unregisterEndpoint 3. lookupEndpoint 4. lookupEndpoints you could invoke 3 or 4 operation in your ps/sql, and have to write the strategy (random, round robin ...) to process the retrieved endpoints then invoke the service from the selected endpoint. I don't think you need add any SL library in this case. HTH
