Problem solve Get help with specific problems with your technologies, process and projects.

Error on calling a stored procedure with java code

I am calling a stored procedure through java code. This stored procedure in turn calls another one, and then I recieve an error message, "ORA-06508: PL/SQL: could not find program unit being called".

The suprising thing here is that the application runs fine for 3 to 4 days and later I start recieving this error. I am using WebLogic application server's connection pool to connect to the database.

Can someone please help?

The first thing to check is to ensure that you do not have invalid objects in your database. Invalid objects can cause the ORA-6508 error. Run the following query signed on as the application owner:

SELECT owner, object_name, object_type
FROM all_objects
WHERE status = 'INVALID'; 

If there are invalid objects, recompile them:

ALTER {object type} {object name} COMPILE;

Substitute the appropriate object type and name in the above statement.

The next thing to check is to find out what has changed. ORA-6508 can occur when one applies a patchset or other patches and the Oracle software needs to be recompiled. Or you may consider backing out of the patch if possible.

If all of that fails, you can look at Note 162400.1 on MetaLink, but you'll probably have to open a TAR with Oracle Support to get the problem resolved.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.