Testing Stored Procedures in accelQ

Stored Procedure testing works pretty much in a similar way to database testing, except that a Stored Procedure may return multiple result sets. Before you extract or verify a field value, remember to set the Result Set instance number to work with.

Execute Database Stored Procedure Query

Executes a given Stored Procedure SQL on a database instance. This command returns the count of result sets created by the stored procedure. Reference name provided here can be used to extract/verify field values.

Make sure a db session is already established before executing this command.

Stored Procedure Query

Reference Name

Returns

Query to be executed

Reference name for this query to be used for subsequent data extraction and verification

Number of Results Sets created as a result of this query

Select Result Set in Stored Procedure query result

Selects the result set from a previously executed stored procedure query. When you execute a stored procedure, multiple result sets may be created. Perform this command before extracting or verifying field values from the query.

Stored procedure ref name

Result set number

Reference name of the stored procedure from which results are retrieved

result set number, from which results are retrieved (starts from 1)

Once you execute this command, you can use Get Database Field Value and Verify Database Field Value commands for verifying the response content.