Inside a procedure, I use a table variable to store the some result from table A .
I have to use this table variable in dynamic sql .
Call Procedure A()
VAR_TAB = select customer_id from table_A;
EXEC ' select * from'||: var_tab;
The above code will throw error. Anyone has a solution for this ?