You are trying push cursor results from one procedure to another, I do not know if that is allowed

Alternatively, you can push your results into a temp table, like

CREATE VIRTUAL PROCEDURE
BEGIN
INSERT INTO #myTemp SELECT * FROM (EXEC virtual_procedure1 (value1)) AS @categoryid;
EXEC procedure2 ();
END

Then read from #myTemp in procedure2

Ramesh..

> You are trying push cursor results from one procedure to another, I do not know if that is allowed

No, we don't have a notion of passing a cursor to a source procedure.

What does procedure2 expect as input?

Morgan,

If procedure2 expects a integer from procedure1, then you can try without the #temp table stuff, I was thinking procedure1 returns a result set.

CREATE VIRTUAL PROCEDURE 
BEGIN 
  DECLARE integer x = EXEC virtual_procedure1 (value1);
  EXEC procedure2 (x); 
END

Ramesh..

> Thanks Stephen, procedure2 expects an integer value that is an output from procedure1

If it is a scalar result, then you can use a scalar subquery:

EXEC procedure2 ((SELECT intval FROM (EXEC virtual_procedure1 (value1)) AS x));

If you need to process a resultset of integers, then you would use Ramesh's suggestion:

LOOP ON (EXEC virtual_procedure1 (value1)) AS vals

BEGIN

     --do something with EXEC procedure2(vals.intval)

END

> TEIID30146 No procedure plan exists for virtual_procedure1.

That is not expected.  Can you provide a reproducing vdb?