title: Validating a PL/SQL Stored Procedure OUT REF CURSOR in SQL Developer's Unit Testing framework
body: <p>I am developing a series of PL/SQL Stored Procedures in a package that open REF CURSORs that are passed to the caller as OUT parameters for purposes of interoperability with another framework. I am using SQL Developer and recently started looking into using the testing features built into it.</p>
  
  <p>I am looking for a way to validate the results of a REF CURSOR using SQL Developer's Unit Testing framework. I developed some paging logic, and I want to ensure that it is operating correctly so I was hoping I could verify that I have the correct number of rows and that their row numbers are within the range of the appropriate page.</p>
  
  <p>I found a similar question <a href="https://forums.oracle.com/forums/thread.jspa?threadID=2131008" rel="nofollow">here</a>, but that solution renders the unit tests absolutely useless (at least as far as I can tell) because it doesn't actually perform any validation after running the procedure. If someone could explain how to validate it or show me what I'm missing from the solution from Oracle's Forums, I would appreciate it.</p>