Re: Mysterious corruption of procedures?

Hello,

I don't know if it would help you, but I had this problem with an Oracle Server version 7.1.4.1.1 (NCR 3555 Unix System V release 2.02) on corrupted views.
The problem was the timestamp of validation between dependencies of objects referenced in these views.
Perhaps you've got the same sort of problem. To find out if it is the same problem apply this query:

select distinct(o2.obj#)
from obj$ o, dependency$ d, obj$ o2

where o.obj# = d.p_obj#
and o.stime != d.p_timestamp
and d.d_obj# = o2.obj#

If it returns something (object id which corresponds to one of your procedure) contact your Oracle customer to get a patch or something like that ...

Good luck.

PS: We are now in version 7.2.3.0.0 and it seems to work better.

Shaun Mallory <S.mallory_at_ehv.sc.philips.com> wrote in article <3290E9B2.7258_at_ehv.sc.philips.com>...
> I need help trying to figure out what is happening to my database. I
> have an application that uses a number of stored procedures for various
> things. These procedures compile without error and are used
> successfully in the application. Most of the time!
>
> Occasionally, however, the compiled procedures becomes corrupted and
> needs to be recompiled with the ALTER PROCEDURE...COMPILE command. I
> have no idea why this is occurring and where to start looking for the
> cause.
>
> If anyone knows how I might begin to trace this fault please let me
> know.
> The Oracle server is version 7.2.3.0.0
> the PL/SQL is version 2.2.3.0.0
> and it is installed in an HP-UX v10.1 environment.
>
> Thanks in advance for any pointers
>
> Shaun Mallory
> S.Mallory_at_ehv.sc.philips.com
>
  Received on Tue Nov 19 1996 - 00:00:00 CET