Test manager - Enhancement request

[Graham Oakes]

Hi,

I'm enjoying using the test manager, but one thing that would make life easier is being able to set an expected result for a ref cursor.

At the moment I can see that my procedure run quickly enough but if they're not returning any rows / or the expected rows in the cursor then I'd like to know about it.

Thanks
Graham

 

[Marco Kalter]

The only way to implement such "complex" checks is to implement them in the PL/SQL Block of the Test Script itself. You can process the result set, and return an variable that indicates if the result set is okay.

 

[Graham Oakes]

Hi Marco,

I'd come to that conclusion myself but thought if I moaned enough someone might make an enhancement for the future

I had something in mind like a button on the display cursor results page that would save the results to a table (name prompted for in a popup box).

Then an option on the main test manager page to set the expected output to the name of the table, thus enabling a full check of the results.

Thanks anyway
Graham