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:
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:
Was this information helpful?
Other articles
- What is the signature mode of remote dependency?
- What are the components of a DML trigger?
- What is the UTL_FILE Oracle supplied package?
- What is a package?
- What is the syntax for creating a DDL trigger?