title: How to pass a Ref Cursor as an argument to a Stored Procedure?
body: <p>How to pass a Ref Cursor as an argument to a Stored Procedure?</p>
  
  <p>I am trying to call a stored procedure that expects cursor as a parameter.The Cursor used in the stored procedure as out parameter. Both the stored procedure and cursor are defined in a package.</p>
  
  <p><strong>How to call the stored procedure by passing the cursor?
  Please explain with an example</strong></p>
  
  <p>This how the procedure and cursor are written.</p>
  
  <pre><code>PACKAGE company
  IS
  
  /* Define the REF CURSOR type. */
  TYPE curvar_type IS REF CURSOR RETURN company%ROWTYPE;
  
  /* Stored Procedure Impl */
  PROCEDURE open_company (curvar_out OUT company.curvar_type) IS
  BEGIN
     ...
  END;
  END package;
  </code></pre>
  
  <p>Thanks in advance.</p>