Snowflake Execute Immediate使用USING变量报错求助
问题原因及解决方法
- 报错根源是USING子句的语法错误:Snowflake中使用USING传递参数时,参数不需要用括号包裹。
- 错误写法:
execute immediate 'select ''hi'' as textvalue, ? as numbervalue' using (5) ; - 正确写法:
execute immediate 'select ''hi'' as textvalue, ? as numbervalue' using 5 ; - 补充:如果需要传递多个参数,直接用逗号分隔即可,同样无需括号,示例:
execute immediate 'select ? as textvalue, ? as numbervalue' using 'hi', 5 ;
内容的提问来源于stack exchange,提问作者Eric
相关产品推荐
相关产品推荐

