Snowflake - passing a dynamic value to stored procedure in call statement w

Question

var P_ENV = 'int' var p_sqlText: CALL LS_**${P_ENV}**.HIID_SECURED.sp_getStatCertSaltValue(:1,:2); var stmt = snowflake.createStatement({sqlText:p_sqlText,binds: [P_ENV,P_STARTCERTID] });

    var rs = stmt.execute();
    rs.next();
    var p_saltvalue= rs.getColumnValue(1);

Unable to execute these lines in an stored procedure - calling the stored procedure with in the stored procedure - Thoughts please

Gokhan Atil · Accepted Answer · 2021-03-19 12:54:21Z

1

Can you share the error message you get?

When I tried to test it, I was able to call the procedure:

create or replace procedure int_sp_getStatCertSaltValue( v1 varchar, v2 varchar)
returns object
language javascript
as
$$
  return { "v1": V1, "v2": V2 };
$$;

create or replace procedure spinsp()
returns object
language javascript
as
$$
 var P_ENV = 'int';
 var P_STARTCERTID = 1
 var p_sqlText = `CALL ${P_ENV}_sp_getStatCertSaltValue(:1,:2)`; 
 var stmt = snowflake.createStatement({sqlText:p_sqlText,binds: [P_ENV,P_STARTCERTID] });
 var res = stmt.execute();
 res.next();
 return res.getColumnValue(1);
$$
;

call spinsp();


+----------------------------+
|           SPINSP           |
+----------------------------+
| { "v1": "int", "v2": "1" } |
+----------------------------+

answered Mar 19, 2021 at 12:54

Gokhan Atil

10.6k2 gold badges13 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Snowflake - passing a dynamic value to stored procedure in call statement w

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related