is there a privilege issue here? Raj On 8/5/05, Billy Verreynne (JW) <VerreyB@xxxxxxxxxxxx> wrote: > > > 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 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > -- > //www.freelists.org/webpage/oracle-l > -- ------------------------------ select standard_disclaimer from company_requirements where category = 'MANDATORY';