How do I store data from virtual procedure into table?

[shiloh.jordan]

I have a virtual procedure that successfully takes input parameter and outputs the correct data.  Now, I am trying to store this data into table. 

Do you have any ideas?

I keep getting this error below but I tried adding double quotes ("") around the Electors0008 and testPROC but when I save, they are removed.

All help is appreciated

Thanks,

Shiloh

[rareddy]

Take the "Electors008." portion of the path and see if that makes any difference.

[shawkins]

You cannot direct use a view column as a parameter, but there is a related syntax - see procedural relational DML Commands · Teiid Documentation

You would instead use:

select cols ..., filepath from testProc

and add filepath as a column to the view.

Then the user could issue:

select * from FinalView_Tbl where filepath = 'something'

and get a result.  However the engine would produce an error if you just issued "select * from FinalView_Tbl"