title: Execute stored procedure inside another stored procedure in snowflake
body: <p>We created 2 stored procedures separately in snowflake. Now we have master stored procedure which we need to execute. This master stored procedure is written is way that the return value of first stored procedure would trigger second stored procedure.</p>
  <p>When I am assigning return value of first stored procedure to variable , it seems like it is not getting assigned.</p>
  <pre><code>var CALL_CATALOG_SP_return_val= snowflake.execute({ sqlText: CALL_CATALOG_SP });
  </code></pre>
  <p>How do I ensure that I am second stored procedure runs only when I get particular value from first stored procedure.</p>