tbl name as paramater marker

smpa01
Contributor

I am getting an error here, when I do this

//this works fine
declare sqlStr = 'select col1 from catalog.schema.tbl LIMIT (?)';
declare arg1 = 500;
EXECUTE IMMEDIATE sqlStr USING arg1;

//this does not
declare sqlStr = 'select col1 from (?) LIMIT (?)';
declare arg1 = 'catalog.schema.tbl'
declare arg2 = 500;
EXECUTE IMMEDIATE sqlStr USING arg1,arg2;

 

doc1 doc2 

Thank you in advance