This discussion is archived
9 Replies Latest reply: Sep 3, 2013 2:23 AM by dwhittin RSS

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

618497 Newbie
Currently Being Moderated

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...




  • Correct Answers - 10 points
  • Helpful Answers - 5 points