Stored Procedures are similar to user-defined functions that are invoked using Cal Procedure or Execute Procedure statements. The output of these procedures is generally in the form of result sets. The stored procedures are stored in RDBMS and are readily available for the applications.
These can be tested using the following techniques :
White box testing : Here, the stubs are used for invoking stored procedures and the results of those are validated against our expected results.
Black box testing : We perform operations on the front-end view of our application in a way that the stored procedures are invoked and we validate the result by observing the changes in the view.
