Skip to Content
0
Mar 13, 2016 at 06:31 PM

How to use table variable in dynamic sql

736 Views

Hi ,

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 ?

Thanks,

Yogesh