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