javascript - 雪花程序问题：Proc调用不在雪花程序中，在雪花工作区中起作用(Snowflake Procedure Issue: Proc call works in Snowflake Workspace NOT within a Snowflake Procedure)

Question

When I run the procedure call in Snowflake Worksheet the proc works: spv_my_log( 'PROC_NAME'::variant ,'ERR_CODE'::variant , 'ERR_MSG'::variant , 'ERR_STATE'::variant , 'ERR_DESC'::variant , 'ERR_LINE_NO'::variant, 'ERR_STACK'::variant , 'MSG1'::variant , 'MSG2'::variant );

(当我在Snowflake Worksheet中运行过程调用时，proc会起作用： spv_my_log（'PROC_NAME':: variant，'ERR_CODE':: variant，'ERR_MSG':: variant，'ERR_STATE':: variant，'ERR_DESC'::: variant， 'ERR_LINE_NO':: variant，'ERR_STACK':: variant，'MSG1':: variant，'MSG2':: variant）;)

With the same procedure call made inside a proc in Snowflake it fails with the following Exception JavaScript compilation error: Uncaught SyntaxError: missing ) after argument list in SPV_MY_TEST at ' spv_my_log( 'PROC_NAME'::variant ,'ERR_CODE'::variant , 'ERR_MSG'::variant , 'ERR_STATE'::variant , 'ERR_DESC'::variant , 'ERR_LINE_NO'::variant, 'ERR_STACK'::variant , 'MSG1'::variant , 'MSG2'::variant );'

(在Snowflake的proc中进行相同的过程调用后，它将失败，并显示以下异常 JavaScript编译错误：SPV_MY_TEST中的参数列表后的未捕获的SyntaxError：missing），位于spv_my_log（'PROC_NAME':: variant，'ERR_CODE':: variant，' ERR_MSG':: variant，'ERR_STATE':: variant，'ERR_DESC':: variant，'ERR_LINE_NO':: variant，'ERR_STACK':: variant，'MSG1':: variant，'MSG2':: variant）;')

position 19

(位置19)

  ask by Scott Volkers translate from so

Answer 1

等待大神答复