Hi Guys,

Is there anyway to handle exceptions or error messages return by SOAP or REST service invoked by a Teiid Virtual procedure?

CREATE VIRTUAL PROCEDURE

BEGIN

          DECLARE string VARIABLES.INPUT_ENDPOINT;

          VARIABLES.INPUT_ENDPOINT = ServiceManagerServiceView.getDataReport.soapstring;

          SELECT DataHeader.* FROM (EXEC ServiceManagerService.invoke(binding => 'SOAP11', action => '', request => XMLPARSE(DOCUMENT VARIABLES.INPUT_ENDPOINT))) AS ws, XMLTABLE('/*:getHeaderResponse/return/response/report/record' PASSING ws.result COLUMNS ATTRIBUTES XML PATH 'attribute') AS DataHeader;

END

Suppose ServiceManagerService.invoke returns error or exception or no data, what would be the best way of handling the error or exception or no data?

P.S

I publish teiid data as REST service and currently it throws an unhandled excpetion in case ServiceManagerService.invoke returns error or exception or no data.

Thanks for the help!

Regards

Tanmoy Palit