Oracle - Could not find the Program unit

While i compiled my code , it got compiled but while running my application i got the Oracle error "Could not find the Program unit ? "
Can any one tell exactly why this happens.

I had validated all the objects and even released all the Locked objects .
But still this error persisted .
  • Interview Candidate
  • 6
  • 3657

Showing Answers 1 - 6 of 6 Answers

raj_imr2000

  • Jan 15th, 2008
 

Hi,

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.
                      
Cheers!!!!!
raj

  Was this answer useful?  Yes

binurajnair

  • Feb 20th, 2008
 

This error can occur in the following scenario also. The application has a constant connection with the database and a package which the application uses gets recompiled. And the recompiled package contains package variables.

Solution :- Restart the application so that the connection to the database is re established.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions