Takes actual value and expected value, checks that actual value is less or equal to expected value and report failure if actual value is greater than expected.
Arguments
-
V_ActualValue - actual value, Variable Character(255) in Oracle and Netezza, DECIMAL(18,8) in SQL Server
-
V_ExpectedValue - expected value, Variable Character(255) in Oracle and Netezza, DECIMAL(18,8) in SQL Server
-
v_UserMessage – message to report when assertion fails, Variable Character(255) in Oracle and Netezza, NVARCHAR(MAX) in SQL Server
Examples
SQL Server
EXEC DBTD_ASSERT_IS_LESS_OR_EQUAL 5, 6, ‘Values should be smaller or same as expected’;
Oracle
DBTD_ASSERT_IS_LESS_OR_EQUAL (5, 6, ‘Values should be smaller or same as expected’);
Netezza
CALL DBTD_ASSERT_IS_LESS_OR_EQUAL (5, 6, ‘Values should be smaller or same as expected’);
See Also