javascript - 雪花程序传递双变量

Question

我将一个双精度值传递给雪花程序，但是我给它的标识符无效。如何解决问题。

CREATE OR REPLACE PROCEDURE "proc1" (abcd DOUBLE)
RETURNS string not null
LANGUAGE JAVASCRIPT
EXECUTE AS OWNER
AS '
try {
var INS_UPD  = `select 'abcd'+1 from table;`
snowflake.createStatement( {sqlText: INS_UPD} ).execute();
} catch (err) { snowflake.createStatement({sqlText: "ROLLBACK;"} ).execute();
        return "Error: "+err;
    }   
    return ''Success'';
';

给出错误无效的标识符abcd

标签： javascript