dbug_trigger - Perform debugging in Oracle PL/SQL triggers
The dbug_trigger package is used for debugging after row triggers as well as statement triggers.
The dbug package is used by dbug_trigger.
Used to display information about the number of records processed in a DML statement. Each after row dbug trigger will increment the number of records processed. The after statement trigger will finalize the total number of records. The procedure dbms_application_info.set_session_longops() is used to show the information. This can be viewed for instance in Toad using the Long Ops tab in the Session Browser.
Enter a row trigger p_trigger_name of table p_table_name. The trigger mode is specified by either p_inserting, p_updating or p_deleting.
Leave the row trigger. This must always be called if enter was called before, even if an exception has been raised.
Print a line containing info about the column. The parameter p_key denotes whether the column is a key column. The parameter p_column_name shows the column name. Information is only printed in the following occasions: a non null column while inserting; a changed value while updating or the key column while deleting. The p_old_value is only used when the trigger is updating or when it is a key column in a deleting trigger. The new_value is only used for an inserting or updating trigger.
Gert-Jan Paulissen