9 Replies Latest reply: Sep 3, 2013 4:23 AM by Dwhittin-Oracle RSS

    Unit Testing of RefCursor - not matching result sets = SUCCESS - is it bug?


      I am using SQL Developer 3.1.07

      I have created a unit test for a stored procedure returning a ref cursor and noticed that even if I check the "Test Result" check box, the RETURNS$ ref cursor's "result set" is not being compared/tested against the "result set" of the cursor created in the "Dynamic Value Query" to test the stored proc's ref cursor against. The status is shown as SUCCESS even if the result sets have different number of records (not matching contents).

      Is this a feature or a bug?

      Please advise...