Toad World® Forums

How to see result of ref_cursor out var values


#1

How can I see the resulting rows in a ref cursor out variable that I am testing using Code Tester? In the results it says my cursor contains one row, but how do I see what is in the row?


The procedure call looks like:

If I right click the session variable and chose Show DBMS Output it is blank
I should also mention that I don’t expect the cursor to have any rows in this test case.
I have another test case for this procedure where I expect the ref cursor to contain a row, and Code Tester says that it did, making the test successful, but I don’t see the contents of the row.
I saw a similar question/post to this, but it was answered in 2014 and the screens are different.
Thanks
joe