[ https://issues.jboss.org/browse/TEIID-3270?page=com.atlassian.jira.plugin... ] Andrej Šmigala commented on TEIID-3270: --------------------------------------- [~rareddy] yes, does not work either. Interestingly, EXECing the function works, but does not return a result set, but a scalar, so the only way I found to get to the result is something like this: {code:sql} CREATE VIRTUAL FUNCTION f1(p1 integer) RETURNS integer AS RETURN p1; CREATE VIRTUAL PROCEDURE testProc (p integer) RETURNS TABLE ( result integer ) AS BEGIN DECLARE integer VARIABLES.v1 = ( EXEC f1(p)); SELECT VARIABLES.v1 AS result; END; {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)