title: Catch a PL/SQL procedure's RETURN value in command prompt?
body: <p>Currently I'm using</p>
  
  <pre><code>%testvar%=sqlplus usr/password@schema @test.sql
  echo %testvar%
  </code></pre>
  
  <p>where <code>test.sql</code> calls the procedure using <code>BEGIN END</code> block , and saves the returned value in a string variable named <code>x</code> , now how do I return this to command prompt ?</p>