Re: PL/SQL unit MIA

is there a privilege issue here?

Raj

On 8/5/05, Billy Verreynne (JW) <VerreyB_at_telkom.co.za> 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
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
------------------------------
select standard_disclaimer from company_requirements where category = 
'MANDATORY';

--
http://www.freelists.org/webpage/oracle-l