title: Aginity Stored Procedure Error
body: <p>This may be a layman question. Still I surfed on the web and couldn't get through.
  I am getting following error when run simple stored Procedure in Aginity </p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE test() 
  RETURNS VARCHAR(10) 
  LANGUAGE NZPLSQL AS
  BEGIN_PROC
  DECLARE 
  BEGIN 
  RETURN "SUCCESS" 
  END
  END_PROC;
  </code></pre>
  
  <p>No error given when running the above.</p>
  
  <p>Get the error ONLY when execute as follows</p>
  
  <pre><code>EXECUTE TEST();
  </code></pre>
  
  <p>Error:</p>
  
  <pre><code>ERROR [01000] NOTICE:  plpgsql: ERROR during compile of TEST near line 3
  
  ERROR [HY000] ERROR:  missing ; at end of SQL statement
  </code></pre>
  
  <p>Thanks</p>