title: Assigning output parameter from Stored Procedure in oracle
body: <p>Please help me with the following scenario</p>
  
  <p>I need to call a Stored Procedure inside another one. the inner SP would return a number value which I need to store it in a local variable.</p>
  
  <p>rough code</p>
  
  <pre><code>AssignSpResult NUMBER;
  </code></pre>
  
  <p>AssignSpResult = SPtobecalled(Param1,Param2, OutParam);</p>
  
  <p>This syntax is most probably wrong, so please help correct it</p>