There are two ways to test a stored procedure.

1)Black box testing: The Result Set should be checked if the

desired output is returned by SQL command.

2)Performance Testing: Stored Procedures are created to

avoid compiling it again and again. hence, testing should be

done to check if stored procedures are reducing CPU load and

network traffic.