I am trying to call a web service with input parameters and return it as a result set. I couldn't create it as a view since it needs input parameters
CREATE virtual PROCEDURE XYZ (dept int)
BEGIN
select pos.* from ( call WS.invoke(request=>convert({requestXml}, xml), binding='SOAP11')) f,
xmltable(XMLNAMESPACES({namespaces}), '{responseRoot}'
PASSING f.result COLUMNS {fields}) AS pos;
END
But its giving me error TEIID30492 Command must project at least one symbol. What is the syntax for creating a procedure in teiid?
