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: 982
Points: 4134

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: 982
Points: 4134

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.


© 2018 Digcode.com. All rights reserved.