Skip to content

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