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

Examples

This example cancels the automation if a salary higher than 10,000 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;