When framework finds DBTD_USE_TRANSACTION hint procedure call anywhere in the body of the Unit Test procedure, then test runner will wrap this Unit Test into a transaction that will be rolled back after execution, this will return database in to a pre-test state. This hint will force framework to use transaction regardless of the test runner options used during the run.

Note: Supported in Oracle and SQL Server logic, Netezza does not support transactions at this time. 

Arguments

  • v_Message – user message, Variable Characters (4000). Optional parameter, default message 'Transactions will be used'. SQL Server version uses NVARCHAR(MAX) data type.

 

Examples

SQL Server

      EXEC DBTD_USE_TRANSACTION 'Rollback Test at the end, because it does to many changed to the database that cannot be cleaned with TEARDOWN';

Oracle

      CALL DBTD_USE_TRANSACTION ('Rollback Test at the end, because it does to many changed to the database that cannot be cleaned with TEARDOWN');

 

See Also