Property | Description |
---|---|
Parameter type | String |
Syntax | REMOTE_DEPENDENCIES_MODE = { TIMESTAMP | SIGNATURE } |
Default value | TIMESTAMP |
Modifiable | ALTER SESSION , ALTER SYSTEM |
REMOTE_DEPENDENCIES_MODE
specifies how Oracle should handle dependencies upon remote PL/SQL stored procedures.
Values:
TIMESTAMP
The client running the procedure compares the timestamp recorded on the server-side procedure with the current timestamp of the local procedure and executes the procedure only if the timestamps match.
SIGNATURE
Oracle allows the procedure to execute as long as the signatures are considered safe. This setting allows client PL/SQL applications to be run without recompilation.
See Also:
Oracle Database Application Developer's Guide - Fundamentals for information about the consequences of the settings of this parameter