10.12 LOG_ERROR Procedure

This procedure writes a log entry with severity ERROR and is to be used within automation code.

Syntax

APEX_AUTOMATION.LOG_ERROR (
    p_message   IN VARCHAR2 )

Parameters

Parameter	Description
p_message	Message to write to the automation log.

Example

This example writes some log information.The automation uses select * from emp as the automation query.

BEGIN
    IF :SAL > 10000 THEN
         apex_automation.log_error(
             p_message => 'High Salary found for empno: ' || :EMPNO );
    ELSE
        my_logic_package.process_emp(
            p_empno => :EMPNO,
            p_sal => :SAL,
            p_depto => :DEPTNO );
    END IF;
END;