PL/SQL (MOSC)

MOSC Banner

SOA PURGE JOB - PROC ISSUE

edited Sep 5, 2018 11:44AM in PL/SQL (MOSC) 2 commentsAnswered

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;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center