Hi,
I am facing very strange problem. I am using Oracle 11g R2 and i have 1 package which contents multiple procedures. When i perform some operations via application then sometimes 1 got below error or sometimes perform successfully.
Error:- ORA-06508: PL/SQL: could not find program unit being called
Can anyone help me to understand why this type of issue happens and what should i do to resolve permanently?
For ex:- If i performed 10 operations and out of 10 8-9 operations successfully done and 1-2 operations failed.
As per my understanding this error will occur when someone made change in base objects which are used in pckge/proc/func etc so the func/pckge/proc is going in invalid state. To resolve i am doing recompile that object but it will resolve my problem temporary.