topic Re: how to call Service Locator from pl/sql? in Talend Studio

how to call Service Locator from pl/sql?

Anonymous — Sat, 16 Nov 2024 12:00:47 GMT

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

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

Anonymous — Sun, 09 Jun 2013 08:15:20 GMT

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

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

Anonymous — Mon, 10 Jun 2013 05:53:11 GMT

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

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

Anonymous — Mon, 10 Jun 2013 07:31:25 GMT

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