RE: PL/SQL unit MIA

David Wendelken wrote:

> Are there any other invalid items in the database?

Nope. Unless invalidated bitmap indexes can cause this perhaps?

What I find weird is that tracing/debugging showed that it fails when calling a specific procedure. I've also wired it to inform me on my mobile and give the name of the proc that fails (always the same name). Seconds after getting the SMS notification I'm on the cluster looking at it and there are no invalid or missing PL/SQL objects. Except for bitmap indexes (side effect of a partition exchange DDL) - which should not cause an ORA-6508. Logging in as the same schema used to run this DBMS_JOB, I can run

a) the proc in question without errors
b) the schedule proc without errors
c) restart the DMBS_JOB without errors

This within seconds of the notification telling me that the specific PL/SQL unit is missing.

But then I've also ceased to be that surprise with weird Oracle errors. Ran into a few during the last couple of months which made for interesting TARs.

--
Billy

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail and its contents are subject to the Telkom SA Limited
e-mail legal notice available at
http://www.telkom.co.za/TelkomEMailLegalNotice.PDF
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--
http://www.freelists.org/webpage/oracle-l