Saves message with provided type and source into the DBTD_TBL_LOG log table.

 

Arguments

  • V_Type - message type INFO, DEBUG, WARNING, ERROR or user specified. Variable Character (50)
  • V_Source – message source. Variable character (128)
  • V_Message – the message to log, Variable character (4000). SQL Server uses NVARCHAR(MAX) 

 

Examples

SQL Server

      EXEC DBTD_LOG_MESSAGE_EXT 'INFO', 'UT_MYSUITE_CHANGEREQUEST12345', 'My Message';

Oracle

      DBTD_LOG_MESSAGE_EXT ('INFO', 'UT_MYSUITE_CR12345', 'My Message');

Netezza

      CALL DBTD_LOG_MESSAGE_EXT ('INFO', 'UT_MYSUITE_CHANGEREQUEST12345', 'My Message');

 

See Also