Re: PL/SQL package gets invalidated seemingly at random

"Javier Sanchez" <javier_nicolas_sanchez_at_hotmail.com> wrote in message news:975c1541.0401091432.1f34c849_at_posting.google.com...
| Hi all,
| I am experiencing a problem whereby a PL/SQL package is valid for
| some time (and runs succesfully a few times) and then suddenly becomes
| invalid in DB. If I recompile this package it works again for some
| time and then again gets invalidated. Does anyone have a suggestion or
| idea of what might cause such strange behavior?
|
| Also, does anyone know a way of obtaining error information from DB
| that reports why a package was flagged as invalid?
| Finally, I would appreciate help on how to obtain dependencies (both
| direct and indirect) for a package? (I read in the documentation that
| a change in a dependency can cause a package to be invalid)
|
| Thanks for your help, regards,
|
| -Javier

a change in dependencies is the typical reason

use the data dictionary view USER_DEPENDENCIES or DBA_DEPENDENCIES to (recursively) examine objects that a package depends on

whenever possible, avoid making changes to the package specification -- only work with the package body, this reduces invalidation of dependent packages and procedures

• mcs