Hi all...
It seems this question was asked many times in this forum,sorry for asking this again.
I am calling a procedure in a package, i am getting the following error.
I recompiled the package and it recompiled without any errors.
I have also checked the status of the package too. It is in valid status
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped stored procedure
"ABC_MBR.ABC_TABLES_API"
ORA-06508: PL/SQL: could not find program unit being called:
"ABC_MBR.ABC_TABLES_API"
ORA-06512: at "ABC_MBR_STG.ABC_INTERFACE", line 1055
ORA-06512: at line 2
SQL> select status, object_type,owner from dba_objects where object_name='ABC_TABLES_API';
Press return to continue
STATUS OBJECT_TYPE OWNER
------- ------------------- ------------------------------
VALID SYNONYM APPS
VALID SYNONYM ABCSERV
VALID PACKAGE ABC_MBR
VALID PACKAGE BODY ABC_MBR
Is there any other things that i need to check?
If the package i am calling has any dependent objects ..do i need to check all the dependent objects , whether they are valid or not?
Please let me know what shall i do to fix this error..
Thanks in advance..