title: Run oracle procedure with cursor
body: <p>I am not experienced with db (actually not at all) and I face a problem:<br>
  I have oracle 11g and I am using PL/SQL developer.<br>
  I have a simple procedure :  </p>
  
  <pre><code>type t_ref_cursor is ref cursor;
  
  procedure fakeProc (
         io_cursor        in out t_ref_cursor
        )
     is
        begin
  
        open io_cursor for
        SELECT * from myTable;
  
   end fakeProc;
  </code></pre>
  
  <p>Now I want to run it as a SQL window (not in a test window)
  What I am trying to run:</p>
  
  <pre><code> v_cur         cursor;
   begin
      fakeProc(:v_cur);
   end;
  </code></pre>
  
  <p>I get errors:
  ORA-00900:Invalid SQL statement
  ORA-01008:not all variables bound</p>
  
  <p>So can you point me the right way to run a procedure like this(with begin -end)?</p>