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