Oracle Error :: ORA-06508
PL/SQL: could not find program unit being called
Cause
An attempt was made to call a stored program that could not be found. The program may have been dropped or incompatibly modified, or have compiled with errors.
Action
Check that all referenced programs, including their package bodies, exist and are compatible.
Comments (Add Comment)
10/02/2010 10:03:28 by Chandra Kishore Kovuru
When I faced this problem, I checked for all procedures status in user_objects, to my surprise I found two packages with the same name one in valid state and another in invalid state. When I dropped the package both of them got dropped and later created the package the problem was resolved.