Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-28-2025 11:31 AM
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;
Thank you in advance