title: Put stored procedure result/output into variable
body: <p>I have a stored procedure that I'm working with where I'm calling another stored procedure within. The nested procedure accepts a value and returns an ID based on that successfully, but I can't seem to figure out how to cast that result into a variable for another stored procedure in the same wrapper.</p>
  
  <p>Where I am now:</p>
  
  <pre><code>P1: BEGIN ATOMIC
  
  CALL GET_ID_BY_VALUE(P_VALUE);
  
  -- want to store output into V_NEW_ID
  
  CALL NEW_PROCEDURE(V_NEW_ID);
  
  END P1;
  </code></pre>
  
  <p>Does that make sense?</p>