What is remote dependency?
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.
What is remote dependency?
Rating:
In the case of remote dependencies, the dependent and the referenced objects are on separate nodes. The Oracle server does not manage dependencies among remote schema objects other than procedure-to-procedure dependencies (including functions, packages, and triggers).
When a remote referenced procedure is modified and recompiled, the local dependent procedure becomes invalid. The first time the dependent local procedure is called, an error message is returned and the procedure remains invalid. However, the second time the local procedure is called, it is automatically recompiled and becomes valid.
Rating:
Was this information helpful?
Other articles
- What are the development steps for creating a procedure?
- What are formal and actual parameters?
- What is object privilege?
- When is the recompilation of a dependent procedure or function successful?
- What is an INSTEAD OF trigger?