When is the recompilation of a dependent procedure or function successful?

When is the recompilation of a dependent procedure or function successful?

Rating:

If the definition of a referenced table is altered, the dependent procedures and functions become invalid. The dependent procedures and functions need implicit or explicit recompilation in order to become valid.

The recompilation of a dependent procedure or function is successful in the following cases:

If the referenced table has new columns, and no new column has been defined as NOT NULL.

If the datatype of referenced columns has not been changed.

If the PL/SQL body of a referenced procedure has been modified and recompiled successfully.

When a private table is referenced by a dependent procedure, and the private table is dropped, the status of the dependent procedure becomes invalid. When the procedure is recompiled, either explicitly or implicitly, and a public table having the same name and structure exists, the procedure recompiles successfully but becomes dependent on the public table. The recompilation is successful only if the public table contains the columns that the procedure requires; otherwise, the status of the procedure remains invalid.

Rating: