Procedures send info, produced by the running process, to an interface using the oracle system package DBMS_OUTPUT. The interface and use of these procedures is very simple (see the code of the procedures). Code can be altered in order to send the info to a more sophisticated environment, e.g. log files or log tables.
PROCESS LOGGING consists of two procedures and a function. They are summarised in the table below.
|ADD_PROCESS_LOG||send a message text to the user interface of the client.|
|ADD_PROCESS_METRICS||send a text containing a summary of results to the user interface of the client.|
|MERGE_PROCESS_METRICS||send a text containing an additional summary of results to the user interface of the client.|