When framework finds DBTD_RUN_ONCE hint procedure call anywhere in the body of Suite Setup or Suite Teardown procedures, such setup or teardown will be executed only once for a suite. Default framework functionality will launch setup and teardown independently for each unit test in the suite.
When DBTD_RUN_ONCE called directly it will insert a user message into the DBTD_TBL_LOG log table.
Arguments
-
v_Message – user message, Variable Characters (4000). Optional parameter, default message 'This procedure will only run once'. SQL Server version uses NVARCHAR(MAX) data type.
Examples
SQL Server
EXEC DBTD_RUN_ONCE ‘Run “fill-up-tank” setup procedure only once for “test-engine” suite’;
Oracle
DBTD_RUN_ONCE (‘Run “fill-up-tank” setup procedure only once for “test-engine” suite’);
Netezza
CALL DBTD_RUN_ONCE (‘Run “fill-up-tank” setup procedure only once for “test-engine” suite’);
See Also