Error ora-06508: PL/SQL: could not find program unit being called

Asked By cyandace 10 points N/A Posted on - 07/18/2011

Hello,

I have a very strange error. We have a database with multiple schemas, now in one schema a new error occurs. This is the situation:
I have a view, with a call to package 'A' which calls package 'B'.When I do a select on the view in SQL/Plus , I get error
ora-06508: PL/SQL: could not find program unit being called

Here all the units are valid. If I recompile the units which are called, the problem disappears but after a few hours it re-appears. We try to increase server shared memory also but that didn't help. Can any one suggest the solution for this?

Regards,
Cyan.

 

• Status: Open
• Question Views: 3133
• Answer Count: 1
• Vote Up 1 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By shethkushal 5 points N/A #84891

Error ora-06508: PL/SQL: could not find program unit being called

There are a couple of problems that could be causing the ORA-6508 error. Normally, this error message is issued in conjunction with other error messages. So try to find out if you have other error messages. This can lead you to your solution.

Another cause is that your package or procedure needs a dependent object which has become invalid. Compiling the dependent object and this object can fix the problem. DDL statements against the dependent object are the leading cause of the INVALID status.

 

Do not drop Database object, instead re-compile to make any change. In SOA server specify validate-connection in JDBC settings. Finally, if things still don't work RESTART SOA server.

 

About shethkushal

Questions
0

Answers
9

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/28/2011
• Question Category: Oracle Database