This procedure skips processing of the current row and continues with the next one. Use this procedure in automation action code.

Syntax

APEX_AUTOMATION.SKIP_CURRENT_ROW (
    p_log_message   IN VARCHAR2 DEFAULT NULL )

Parameters

Examples

This example skips the rest of processing for the current row (PRESIDENT row). The automation uses select * from emp as the automation query.

BEGIN
    IF :ENAME = 'PRESIDENT' THEN
        apex_automation.skip_current_row( p_log_message => 'PRESIDENT skipped' );
    ELSE
        my_logic_package.process_emp( 
            p_empno  => :EMPNO,
            p_sal    => :SAL,
            p_depto  => :DEPTNO );
    END IF;
END;