SOA PURGE JOB - PROC ISSUE
I am using the below Proc to delete the records on CUBE_INSTANCE table on SOA database.
I am getting Pl/SQL completed successfully message. Even after this proc is running few delete statements in background. Is there anyway to track this proc when it got completed successfully with all background delete statements spanned by this proc?
whenever sqlerror exit SQL.SQLCODE;
SELECT 'Starting purge @' || TO_CHAR( sysdate, 'DD-MON-YYYY HH24:MI:SS' ) FROM DUAL;
DELETE FROM JOB_FLOW_CONTROL;
COMMIT;
DECLARE
max_creation_date cube_instance.creation_date%TYPE;
min_creation_date cube_instance.creation_date%TYPE;
batch_size integer;