8.12 SKIP_CURRENT_ROW Procedure

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

Syntax

APEX_AUTOMATION.SKIP_CURRENT_ROW(
    p_log_message             IN VARCHAR2 DEFAULT NULL );

Parameters

Parameter	Description
p_log_message	Message to write to the automation log.

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;