title: How to capture return value from Netezza stored procedure into a variable?
body: <p>I'll be grateful if someone point me to the correct way to capture Netezza stored procedure return value into a variable.</p>
  
  <pre><code>create or replace procedure test() returns varchar(10) language nzplsql as
  begin
   return "success";
  end;
  </code></pre>
  
  <p>and then something like(in another procedure)</p>
  
  <pre><code>var_name := call test();
  </code></pre>
  
  <p>to capture "success" into variable <code>var_name</code></p>
  
  <p>Thanks a lot.</p>