PROCESS LOGGING

Introduction

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.

procedure/function	remarks
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.