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 .

Eg)

Call Procedure A()

Begin

VAR_TAB = select customer_id from table_A;

EXEC ' select * from'||: var_tab;

End;

The above code will throw error. Anyone has a solution for this ?