LEHS - Log- and Exception Handling System for ORACLE


Package pkg_lehs_trace_file_appender

This is an Appender Package for LEHS. Look at PKG_LEHS_APPENDER on more detailed Information about developing an Appender Package.

You can use this Package by registering it as an Appender to a Log-Application (see PKG_LEHS_SYSTEM.register_appender).


This Appender Package logs all Log-Entries to the Trace File of the actual Session.

Appender Parameters:
Parameter Name Datatype valid Values Description
LOG_FORMAT PKG_LEHS_APPENDER.pst_param_value_clob Look at PKG_LEHS_APPENDER.format_log_message Format of the Log-Message


Field Summary
 VARCHAR2(30)pc_param_format
           Parameter Name: LOG_FORMAT

Method Summary
 check_param(pi_application PKG_LEHS_APPENDER.pst_application_name, pi_name PKG_LEHS_APPENDER.pst_parameter_name, pi_value PKG_LEHS_APPENDER.pst_param_value_clob)
           Checks the Value of an Appender Parameter.
 cleanup(pi_application PKG_LEHS_APPENDER.pst_application_name)
           Cleans up the internal used Buffer for the Log-Application
 initialize(pi_application PKG_LEHS_APPENDER.pst_application_name)
           Initializes the Appender.
 log(pi_log_line PKG_LEHS_APPENDER.pr_log_line)
           Adds a single Log-Entry to the Table LEHS_LOG_TABLE_BASIC
 set_param(pi_application PKG_LEHS_APPENDER.pst_application_name, pi_name PKG_LEHS_APPENDER.pst_parameter_name, pi_value PKG_LEHS_APPENDER.pst_param_value_clob)
           Sets the registered Appender Parameter during the Initialization of the Appender

Field Detail

pc_param_format

  public VARCHAR2(30) pc_param_format
Parameter Name: LOG_FORMAT

Method Detail

check_param

  public  check_param(pi_application PKG_LEHS_APPENDER.pst_application_name, 
pi_name PKG_LEHS_APPENDER.pst_parameter_name,
pi_value PKG_LEHS_APPENDER.pst_param_value_clob)
Checks the Value of an Appender Parameter.

Will be automatically called by PKG_LEHS_SYSTEM.set_appender_parameter

Parameters:
pi_application - Name of the Log-Application
pi_name - Name of the Appender Parameter
pi_value - Value of the Appender Parameter
Throws:
ORA-20009 - [INVALID APPENDER PARAMETER NAME] Invalid Parameter Name or Datatype of this Parameter is invalid
ORA-20009 - [FAILED ASSERTION FOR APPENDER PARAMETER WITH REASON] The Value of the Parameter is invalid

initialize

  public  initialize(pi_application PKG_LEHS_APPENDER.pst_application_name)
Initializes the Appender.

Would be automatically called by the Appender Initialization

Parameters:
pi_application - Name of the Log-Application

set_param

  public  set_param(pi_application PKG_LEHS_APPENDER.pst_application_name, 
pi_name PKG_LEHS_APPENDER.pst_parameter_name,
pi_value PKG_LEHS_APPENDER.pst_param_value_clob)
Sets the registered Appender Parameter during the Initialization of the Appender
Parameters:
pi_application - Name of the Log-Application
pi_name - Name of the Appender Parameter
pi_value - Value of the Appender Parameter

log

  public  log(pi_log_line PKG_LEHS_APPENDER.pr_log_line)
Adds a single Log-Entry to the Table LEHS_LOG_TABLE_BASIC
Parameters:
pi_log_line - Log Information provided by LEHS

cleanup

  public  cleanup(pi_application PKG_LEHS_APPENDER.pst_application_name)
Cleans up the internal used Buffer for the Log-Application
Parameters:
pi_application - Name of the Log-Application

LEHS - Log- and Exception Handling System for ORACLE