ENTER Procedure

This procedure logs messages at level c_log_level_app_enter. Use APEX_DEBUG.ENTER() to log the routine name and it's arguments at the beginning of a procedure or function.

Syntax

APEX_DEBUG.ENTER ( 
p_routine_name     IN VARCHAR2, 
p_name01           IN VARCHAR2    DEFAULT NULL, 
p_value01          IN VARCHAR2    DEFAULT NULL, 
p_name02           IN VARCHAR2    DEFAULT NULL, 
p_value02          IN VARCHAR2    DEFAULT NULL, 
p_name03           IN VARCHAR2    DEFAULT NULL, 
p_value03          IN VARCHAR2    DEFAULT NULL, 
p_name04           IN VARCHAR2    DEFAULT NULL, 
p_value04          IN VARCHAR2    DEFAULT NULL, 
p_name05           IN VARCHAR2    DEFAULT NULL, 
p_value05          IN VARCHAR2    DEFAULT NULL, 
p_name06           IN VARCHAR2    DEFAULT NULL, 
p_value06          IN VARCHAR2    DEFAULT NULL, 
p_name07           IN VARCHAR2    DEFAULT NULL, 
p_value07          IN VARCHAR2    DEFAULT NULL, 
p_name08           IN VARCHAR2    DEFAULT NULL, 
p_value08          IN VARCHAR2    DEFAULT NULL, 
p_name09           IN VARCHAR2    DEFAULT NULL, 
p_value09          IN VARCHAR2    DEFAULT NULL, 
p_name10           IN VARCHAR2    DEFAULT NULL, 
p_value10          IN VARCHAR2    DEFAULT NULL, 
p_value_max_length IN PLS_INTEGER DEFAULT 1000 );

Parameters

Table 18-2 APEX_DEBUG.ENTER Procedure Parameters

Parameter	Description
`p_routine_name`	The name of the procedure or function.
`p_namexx`/`p_valuexx`	The procedure or function parameter name and value.
`p_value_max_length`	The `p_valuexx` values is truncated to this length.

Example

This example shows how to use APEX_ENTER to add a debug message at the beginning of a procedure.

procedure foo ( 
    p_widget_id in number, 
    p_additional_data in varchar2, 
    p_emp_rec in emp%rowtype ) 
is 
begin 
    apex_debug.enter('foo', 
        'p_widget_id' , p_widget_id, 
        'p_additional_data', p_additional_data, 
        'p_emp_rec.id' , p_emp_rec.id ); 
....do something.... 
end foo;