web analytics
ORA-06508: PL/SQL: could not find program unit being called Options
codeling
Posted: Tuesday, March 22, 2016 4:33:43 PM

Rank:Advanced Member
Groups: Member
Joined: 12/11/2015
Posts: 915
Points: 3843

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.

Sponsor
Posted: Tuesday, March 22, 2016 4:33:43 PM
 
codeling
Posted: Tuesday, March 22, 2016 4:36:47 PM

Rank:Advanced Member
Groups: Member
Joined: 12/11/2015
Posts: 915
Points: 3843

You can run this query to find invalid objects, which may cause the ORA-06508 error:

select  *

from all_objects

where status = 'INVALID'

  and owner = 'DEV'; --your schema name

Users browsing this topic
Guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.


© 2017 Digcode.com. All rights reserved.