Am passing a double value to snowflake procedure and however I give it gives me invalid identifier. How to solve the issue.
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'';
';
Giving error Invalid identifier abcd