title: TORA Execute Package Procedure with OUT REF CURSOR
body: <p>I'm trying to execute a Package Procedure that has a couple in parameters and a REF CURSOR out parameter but can't seem to figure it out for <a href="http://torasql.com/" rel="nofollow">TORA</a> (my SQL IDE)</p>
  
  <p>Here is a contrived example of a procedure I'd like to execute and see the cursor for:</p>
  
  <pre><code>PROCEDURE get_peeps_in_city ( pi_city IN varchar(100), po_recordset OUT REF CURSOR )
      IS
      BEGIN
           OPEN po_recordset
           FOR Select Id, 
                  FName, 
                  LName
               FROM People
               WHERE City like '%' || pi_city || '%'
      END;
  </code></pre>
  
  <p>Here is what I've tried so far:</p>
  
  <pre><code>DECLARE
      v_cursor REF CURSOR;
  BEGIN
      execute PKG_PEEPS.get_peeps_in_city('Chicago', v_cursor);
  END
  </code></pre>
  
  <p>The error that I get is something along the lines of:</p>
  
  <blockquote>
    <p>PLS-00103: Encountered the symbol "END" when expecting one of the
    following:
    begin function package pragma procedure subtype type use      form    current
    cursor</p>
  </blockquote>