8.5 EXIT Procedure

This procedure exits automation processing, including for remaining rows. Use this procedure in automation action code.

Syntax

APEX_AUTOMATION.EXIT(
    p_log_message             IN VARCHAR2 DEFAULT NULL );

Parameters

Parameter	Description
p_log_message	Message to write to the automation log.

Examples

This example aborts the automation if a salary higher than 10000 is found. The automation uses select * from emp as the automation query.

BEGIN
    IF :SQL > 10000 THEN
        apex_automation.exit( p_log_message => 'Dubious SAL value found. Exit automation.' );
    ELSE
        my_logic_package.process_emp( 
            p_empno  => :EMPNO,
            p_sal    => :SAL,
            p_depto  => :DEPTNO );
    END IF;
END;