title: How to call nested stored create table procedures in Snowflake
body: <p>Looking for advice on how to correct these two stored procedures so that one will trigger the other.</p>
  <p>Stored procedure 2 is designed to simply create Table 2:</p>
  <pre class="lang-sql prettyprint-override"><code>CREATE OR REPLACE PROCEDURE create_table_2()
  returns string not null
  language javascript
  as
  $$
  
  var create_table_2 = `
  create or replace table DATABASE.SCHEMA.TABLE_2
  (
  COL_1 string,
  COL_2 string,
  COL_3 date
  )
  ;
  `
  var create_table_2_cmd = snowflake.createStatement({sqlText: create_table_2});
  var result = sql_create_table_2.execute();
  return 'Table 2 created';
  
  $$;
  </code></pre>
  <p>And stored procedure 1, which should be run first, create table 1 and then run stored procedure 2:</p>
  <pre class="lang-sql prettyprint-override"><code>CREATE OR REPLACE PROCEDURE create_table_1()
  returns string not null
  language javascript
  as
  $$
  
  var create_table_1 = `
  create or replace table DATABASE.SCHEMA.TABLE_1
  (
  COL_1 string,
  COL_2 string,
  COL_3 date
  )
  ;
  `
  var create_table_1_cmd = snowflake.createStatement({sqlText: create_table_1 });
  var result = create_table_1_cmd .execute();
  return 'Table 1 created';
  
  var call_next_function_cmd = `
  call create_table_2();
  ;
  `
  
  var call_next_func = snowflake.createStatement({sqlText: call_next_function_cmd});
  var final = call_next_func.execute();
  
  $$;
  </code></pre>
  <p>The SQL code within the create_table_1() procedure executes without issue but does not call the create_table_2() procedure. Is there an adjustment to be made that can trigger this?</p>