title: Procedure not running in toad asking for the variable
body: <p>I'm using TOAD for Oracle.  I'm trying to execute a stored procedure with two parameters - one IN and one OUT.  It looks like this:</p>
  
  <p>PROCEDURE get_stuff (
        parm_1   IN       VARCHAR2,
        parm_2   OUT      currefcursor) </p>
  
  <p>In the SQL Editor window in TOAD, I've tried various things to no avail.  I'm sure this is something simple that I'm missing, 'cause I've tried all sorts of things I've seen in other solutions here at Experts Exchange, but can't get past various errors.  Here's what I think should work from what I've seen here:</p>
  
  <pre><code> var p1 VARCHAR2 := 'some text';
   var p2 currefcursor;
  
   EXEC get_stuff( :p1, :p2 );
  </code></pre>
  
  <p>When I run this, though, the SQL Editor pops up a window titled 'Variables' that appears to be looking for a value.  No matter whether I put something in the 'Value' textbox or not, when I click OK, it says:</p>
  
  <pre><code>ORA-00900: invalid SQL statement
  </code></pre>
  
  <p>and highlights the 'var' in front of p1.</p>
  
  <p>Please tell me what I'm missing!
  Status Solved Priority Medium Security Public Views 21999</p>