how to call Service Locator from pl/sql?

One Star

how to call Service Locator from pl/sql?

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
Employee

Re: how to call Service Locator from pl/sql?

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
One Star

Re: how to call Service Locator from pl/sql?

We started the tesb-locator-soap-service feature and see those 4 operations.
We will try this suggestion but looks promising.
Thanks
One Star

Re: how to call Service Locator from pl/sql?

We started the tesb-locator-soap-service feature and see those 4 operations.
We will try this suggestion but looks promising.
Thanks