N/APosted on - 07/18/2011
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?
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.