ORA-06508: PL/SQL: could not find program unit being called:
What would be the root cause of the error?
Do I have to check whether the procedure has been created or compiled?
SELECT text FROM USER_SOURCE WHERE NAME='<your procedure name>';
If the above query displays the procedure does it mean that the procedure has been compiled sucessfully?
Do I need to recompile this?
Do I need to pin this pakage using DBMS_KEEP?
How do I recompile this?
Is the following correct method of recompiling a package
ALTER PACKAGE package_name COMPILE BODY;
SELECT object_type, status FROM user_objects WHERE object_name = 'package_name'
How can I flush the shared pool and recompile all invalidated code after making a change?
Do I need to check whether corresponding package body and header exist?
How do I decide what to do?
Do I right away go ahead and recompile the package , check for package header and body, or do I need to do something else first?