10.16 SKIP_CURRENT_ROW Procedure
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
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;
Parent topic: APEX_AUTOMATION