title: SnowScripting: SQL compilation error: syntax error line 6 at position 13 unexpected '<EOF>'
body: <p>I'm new with Snowflake and creating a procedure in Snowflake using Snow Scripting. What could possibly be wrong?</p>
  <pre><code>create or replace procedure test_procedure(p_dob date)
  returns varchar
  language sql
  as
  declare
      v_age NUMBER;
  begin
      v_age := datediff(year, p_dob, current_date);
      return 'Your age is '||v_age::varchar;
  end;
  </code></pre>
  <p>Error msg: SQL compilation error: syntax error line 6 at position 17 unexpected ''.</p>