Hi Freinds,

If any body know about how to test the Stored Procedure ?plz let me know?

Regards,
Vasu

Hi,

Surfed through net and was able to get the below, check whether it helps.

“Each and every stored procedure must be tested at least once!!!”

1.1 individual procedure tests verify the following things and compare them with design specification

* whether a stored procedure is installed in a database
* stored procedure name
* parameter names, parameter types and the number of parameters outputs: * when output is zero (zero row affected)

Outputs
* when some records are extracted
* output contains many records
* what a stored procedure is supposed to do
* what a stored procedure is not supposed to do
* write simple queries to see if a stored procedure populates right data

parameters:
* check parameters if they are required.
* call stored procedures with valid data
* call procedures with boundary data
* make each parameter invalid a time and run a procedure

Return values:
* whether a stored procedure returns values
* when a failure occurs, nonzero must be returned.

Error messages:
* make stored procedure fail and cause every error message to occur at least once
* find out any exception that doesn’t have a predefined error message

Others:
* whether a stored procedure grants correct access privilege to a group/user
* see if a stored procedure hits any trigger error, index error, and rule error
* look into a procedure code and make sure major branches are test covered.

1.2 integration tests of procedures
* group related stored procedures together. Call them in particular order
* if there are many sequences to call a group of procedures, find out equivalent classes and run tests to cover every class.
* make invalid calling sequence and run a group of stored procedures.
· design several test sequences in which end users are likely to do business and do stress tests

Thanks
Deepa

__________________
Arise Awake And Stop Not Till The Goal Is Reached

We have many stored procs in our system. Each one has a specfic purpose. For instance one application awards 'reward points' to a 'client' when a 'Visit' is registered in the database.
How is this tested? Well obviously by a test case, but the test case simply calls for the tester to perform the tasks as follows, a) note the reward points. B) in the application which will record a visit register the visit for the client, then C) verify the amount of the award points has changed.

Any failure will usually show up with an error on screen, even if it doesn't, the points won't be rewarded if the proceedure has not performed.

So basically once you know what a stored proceedure does, you can easily test it.