 | | | PL/SQL unit MIA | PL/SQL unit MIA 2005-08-05 - By rjamya
is there a privilege issue here?
Raj
On 8/5/05, Billy Verreynne (JW) <VerreyB@(protected)> 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 (See ORA-6508.ora-code.com). 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';
is there a privilege issue here?<br>
<br>
Raj<br><br><div><span class="gmail_quote">On 8/5/05, <b class="gmail_sendername
">Billy Verreynne (JW)</b> <<a href="mailto:VerreyB@(protected)">VerreyB
@(protected)</a>> wrote:</span><blockquote class="gmail_quote" style="border
-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left:
1ex;">
<br>David Wendelken wrote:<br><br>> Are there any other invalid items in the
database?<br><br>Nope. Unless invalidated bitmap indexes can cause this perhaps
?<br><br>What I find weird is that tracing/debugging showed that it fails when
<br>calling a specific procedure. I've also wired it to inform me on my<br
>mobile and give the name of the proc that fails (always the same<br>name).
Seconds after getting the SMS notification I'm on the cluster<br>looking at it
and there are no invalid or missing PL/SQL objects.
<br>Except for bitmap indexes (side effect of a partition exchange DDL) -<br
>which should not cause an ORA-6508 (See ORA-6508.ora-code.com). Logging in as the same schema used<br>to
run this DBMS_JOB, I can run<br>a) the proc in question without errors
<br>b) the schedule proc without errors<br>c) restart the DMBS_JOB without
errors<br><br>This within seconds of the notification telling me that the
specific<br>PL/SQL unit is missing.<br><br>But then I've also ceased to be that
surprise with weird Oracle
<br>errors. Ran into a few during the last couple of months which made for<br
>interesting TARs.<br><br><br>--<br>Billy<br><br>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br>This e-mail and its contents are subject
to the Telkom SA Limited
<br>e-mail legal notice available at<br><a href="http://www.telkom.co.za
/TelkomEMailLegalNotice.PDF">http://www.telkom.co.za/TelkomEMailLegalNotice.PDF<
/a><br>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
<br>--<br><a href="http://www.freelists.org/webpage/oracle-l">http://www
.freelists.org/webpage/oracle-l</a><br></blockquote></div><br><br clear="all">
<br>-- <br>-- ---- ---- ---- ---- ---- --<br>select standard_disclaimer from
company_requirements where category = 'MANDATORY';
<br>
|
|
|