Asserts that provided SQL query is successful. Report failure when provided SQL query returns any errors.

Arguments

  • v_SQL - SQL query to run, Variable Character(4000) in Oracle and Netezza, NVARCHAR(MAX) 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_WILL_SUCCEED ‘select a from b’, ‘Specified query should not fail’;

Oracle  

      DBTD_ASSERT_WILL_SUCCEED (‘select a from b’, ‘Specified query should not fail’);

Netezza

      CALL DBTD_ASSERT_WILL_SUCCEED (‘select a from b’, ‘Specified query should not fail’);

 

See Also