Error Message ORA-06508 During Parallel Purge using Debug mode (Doc ID 2407711.1)

Last updated on MAY 01, 2023

Applies to:

Symptoms

When attempting to perform a SOA Parallel Purge with debug on (running @debug_on.sql) the following error occurs.

ERROR
-----------------------
ERROR(delete_inst_in_parallel_job. Error Code = -6508, Error Message = ORA-06508: PL/SQL: could not find program unit being called.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

a) Go to the directory where purge scripts held.

b) Login as DEV_SOAINFRA, load the purge scripts to compile all the objects which will make all packages valid.

SQL>@soa_purge_scripts.sql

c) execute debug_on.sql script

SQL>@common/debug_on.sql

d) Note the invalid packages:

SQL> select owner,object_name,object_type from dba_objects where status='INVALID';

OWNER OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------------------ ------------------------------
ST2_SOAINFRA SOA_ORABPEL PACKAGE BODY
ST2_SOAINFRA SOA_FABRIC PACKAGE BODY
ST2_SOAINFRA SOA_DECISION PACKAGE BODY
ST2_SOAINFRA SOA_WORKFLOW PACKAGE BODY
ST2_SOAINFRA SOA_MEDIATOR PACKAGE BODY
ST2_SOAINFRA SOA_B2B PACKAGE BODY
ST2_SOAINFRA SOA PACKAGE BODY
ST2_SOAINFRA TRS_COMM PACKAGE BODY
ST2_SOAINFRA TRS_BPEL PACKAGE BODY
ST2_SOAINFRA TRS_FAB PACKAGE BODY
ST2_SOAINFRA TRS_DEC PACKAGE BODY
ST2_SOAINFRA TRS_HWF PACKAGE BODY
ST2_SOAINFRA TRS_MED PACKAGE BODY
ST2_SOAINFRA TRS_SOA PACKAGE BODY
ST2_SOAINFRA HWF PACKAGE BODY

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.