Migration from 7.0.1 to 7.0.2 fails with error PLS-00323: subprogram or cursor 'PROCESS_ACTIVE_USER_ACC_MAPS' is declared in a package specification and must be defined in the package body
Originally Published: 2018-05-30
Last Modified: 2023-09-22
Article Number
Applies To
RSA Version/Condition: 7.0.1
Issue
Cause
Error observed
2 Errors found: 55/12 PLS-00323: subprogram or cursor 'PROCESS_ACTIVE_USER_ACC_MAPS' is declared in a package specification and must be defined in the package body 55/12 PLS-00323: subprogram or cursor 'PROCESS_ACTIVE_USER_ACC_MAPS' is declared in a package specification and must be defined in the package body
Resolution
We observed below errors in migrate.log:
Error(s) occurred while compiling invalid object ADC_UPDATE_MASTER_TABLES:
LINE/COL ERROR
55/12 PLS-00323: subprogram or cursor 'PROCESS_ACTIVE_USER_ACC_MAPS' is declared in a package specification and must be defined in the package body
==========================================================================================================================
Error(s) occured while compiling invalid object ADC_UPDATE_MASTER_TABLES:
LINE/COL ERROR
-------- -----------------------------------------------------------------
55/12 PLS-00323: subprogram or cursor 'PROCESS_ACTIVE_USER_ACC_MAPS' is declared in a package specification and must be defined in the package body
--------------------------- Dbms_Output End ---------------------------
[0:00:01] File Completion Time: /home/oracle/database/migration/recompileAll.sql
[0:03:34] Total Migration Time
Executing reporting user statements . . .
....
--------------------------- Dbms_Output End ---------------------------
[0:00:00] File Completion Time: /home/oracle/database/Create Scripts/Create_Synonyms_Public_Schema.sql
[0:03:35] Total Migration Time
Report Summary Begin
2 Errors found:
55/12 PLS-00323: subprogram or cursor 'PROCESS_ACTIVE_USER_ACC_MAPS' is declared in a package specification and must be defined in the package body
55/12 PLS-00323: subprogram or cursor 'PROCESS_ACTIVE_USER_ACC_MAPS' is declared in a package specification and must be defined in the package body
Examine the listed errors within this file. Please address the errors, if necessary, and perform the operation again.
Report Summary End
To verify the invalid objects, please run below commands:
1) select * from user_objects where status='INVALID';
2) select object_name, object_type, owner from dba_objects where status = 'INVALID';
If you see package 'ADC_UPDATE_MASTER_TABLE' listed as invalid object, run below steps to compile the package:
1) Log in as 'oracle' user
2) Log in to sqlplus/avuser
3) cd /packages/collectors/ADC/
@ADC_Update_Master_Tables.pks
@ADC_Update_Master_Tables.pkb
Once above packages are compiled successfully as below:
Run migrate.script manually as follows:
1) cd /home/oracle/database
2) ./migrate.sh
