SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

VALID Objects throw up ORA-04068 error.

441615Jul 14 2006 — edited Jul 14 2006

Hi,

I am trying to execute a stored procedure, but I keep getting this error :-

ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped stored procedure
"CV_L.SP_ST_EXC_CHECK"
ORA-06508: PL/SQL: could not find program unit being called:
"CV_L.SP_ST_EXC_CHECK"
ORA-06512: at "CV_L.SP_EXC_NEXT", line 433
ORA-06512: at line 1

I have verified that the objects mentioned in this exception are valid - the STATUS shows up as VALID in ALL_OBJECTS.

I am not sure if it's a problem with my code ( which compiles ) or an internal instance error. Can you please help me debug this ?

Please do let me know if I need to include more information.

Regards,

Sandeep

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 11 2006

Added on Jul 14 2006

2 comments

377 views