Opening book details…
Can I read Procedure Dependency Management in PL/SQL on EtoBox?
Procedure Dependency Management in PL/SQL by jane027 is a document available to read on EtoBox.
What is Procedure Dependency Management in PL/SQL about?
The document discusses remote procedure dependencies and validation in Oracle databases. Key points: 1. In timestamp mode, a local procedure will execute successfully if its remote dependency has been recompiled, even if the remote timestamp is older than the local one. 2. In signature mode, a procedure will not compile if the signatures of its remote dependencies do not match, such as a parameter data type change. 3. The default remote dependency checking mode in Oracle databases is timestamp mode.
- Author
- jane027
- Language
- EN