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

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

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

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. However, the recompilation of a dependent procedure or function may not always be successful. The recompilation may fail in the following cases:

If the referenced object has been dropped or renamed.

If the datatypes of the referenced columns have been changed.

If one or more referenced columns have been dropped.

If a referenced view has been replaced by a view with different columns.

If the parameter list of a referenced procedure has been modified.

The success of any recompilation is based on the exact dependency. If a referenced view is recreated, any object that is dependent on the view needs to be recompiled. The success of the recompilation depends on the columns that the view now contains, as well as the columns that the dependent object requires for its execution. If the required columns are not part of the new view, the dependent object remains invalid.

Rating: