kbw's avatar
kbw
Contributor
8 years ago
Status:
New Idea

Enhance JDBC test steps to work with stored procedures that return resultsets

It would be helpful if the JDBC test steps, that are configured as stored procedures, could work with stored procedures that return result sets.  The test step should take the returned result set and display it in xml format, as it does with non-stored procedure queries.

 

This is helpful for test steps where we need to return a given query, but some other setup needs to be run in the same session before running the query (such as setting decryption keys).  Currently, this type of scenario can't be handled with JDBC test steps.

 

This of course relies on the chosen JDBC driver / database system itself supporting such returning implicit resultsets.

 

For example, Oracle 12c can return implicit result sets. I've read that MSSQL can as well.

 

Oracle: https://oracle-base.com/articles/12c/implicit-statement-results-12cr1#return_result

 

No CommentsBe the first to comment