Procedure Checks

Previous Next

See Also

Procedure checks are checks that you can add to a (recorded or generated) test procedure. They are written in the form of SQL statements that must evaluate to true or false.

If the SQL statement does NOT select a record, after execution of the test, the log file of the test contains the error message:

ERROR: Procedure check "MYCHECK1" failed.

You can use this mechanism to check the status of the database after executing a procedure. For example, when a procedure is to insert 100 records, you can define a procedure check that counts the number of records actually inserted. You cannot add procedure checks while recording a procedure. Edit the procedure after recording it.