19: --Divide by 3 as deleting from three tables in one transaction
20: --Lower commit size will reduce the chances of Rollback Segment issues.
21: SELECT round(p_commit_size/3)
22: INTO gcommit_size 23: FROM dual; 24:
25: WHILE l_continue LOOP
26: DELETE FROM icx_por_batch_jobs
27: WHERE submission_datetime <= (SYSDATE-p_no_of_days)