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
