title: Oracle SQL Developer - Missing IN or OUT parameter at index:: 1
body: <p>I am having trouble testing this simple stored procedure in Oracle Sql Developer. The stored procedure does a simple select and returns a cursor.</p>
  
  <pre><code>create or replace
  PROCEDURE GET_PROJECT_DRF_HISTORY
  
  ( projectId IN NUMBER,
    resultset_out OUT sys_refcursor
  ) AS
  
  BEGIN
  
    OPEN resultset_out for
    SELECT * from GLIDE_HISTORY
    where GLIDE_HISTORY.PRJ_ID = projectId;
  /*  DBMS_OUTPUT.PUT_LINE(resultset_out);*/
  
  END GET_PROJECT_DRF_HISTORY;
  </code></pre>
  
  <hr>
  
  <p>To test this procedure, I used the below script:</p>
  
  <pre><code>variable results sys_refcursor;
  
  exec get_project_drf_history(3345, :results);
  
  print :results;
  </code></pre>
  
  <hr>
  
  <p>Being new to both oracle and the Sql Developer tool, I am struggling to understand what is the mistake here. I cannot check this in Sql*Plus because I dont have the password to do so. I am using Oracle Sql Developer 1.1.2.25 and Oracle 10g.</p>
  
  <p>Can anybody help me out please? Thank you in advance.</p>