Checks whether the indexes, joins, deletions, update are correct in comparison with tables mentioned in stored procedure. Ensure that the stored procedure is following the standards.

Check the calling procedure name, calling parameters and expected responses for different sets of input parameters.

Run the procedure with database client programs like TOAD or MySQL or Query Analyzer etc.

Rerun the available procedures by sending different parameters, and check the results against expected values.

Concluding to the process, automate the tests with WinRunner.

Database Testing - What steps does a tester take in testing Stored Procedures? - March 13, 2009 at 15:10 pm by Rajmeet Ghai

What steps does a tester take in testing Stored Procedures?

The tester should call the stored procedure in the backend using the EXEC command. Here, if any parameters are required, they must be passed. Different values of parameters must be passed to confirm if the stored procedure is executed or not. On calling this command it must check and verify the nature and behavior of the database. For e.g. if the stored procedure is written to populate some table, the table values must be checked.