Checks that table does not have any records, report failure if table is not empty.
Note:
Oracle framework version uses DBTD_ASSERT_TBL_HAS_NO_RECORDS name for this assert procedure, due to character limit for an object names.
Arguments
-
v_TableName – name of the table, Variable Characters (255) in Oracle and Netezza, SYSNAME in SQL Server
-
v_UserMessage – message to report when assertion fails, Variable Characters (255) in Oracle and Netezza, NVARCHAR(MAX) in SQL Server
Examples
SQL Server
EXEC DBTD_ASSERT_TABLE_HAS_NO_RECORDS ‘table1’, ‘TABLE1 should be empty’;
Oracle
DBTD_ASSERT_TBL_HAS_NO_RECORDS (‘table1’, ‘TABLE1 should be empty’);
Netezza
CALL DBTD_ASSERT_TABLE_HAS_NO_RECORDS (‘table1’, ‘TABLE1 should be empty’);
See Also