String 

REMOTE_DEPENDENCIES_MODE = {TIMESTAMP | SIGNATURE} 

Dynamic. Scope = ALTER SESSION, ALTER SYSTEM. 

TIMESTAMP 

REMOTE_DEPENDENCIES_MODE specifies how Oracle should handle dependencies upon remote PL/SQL stored procedures:

• 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: Oracle8i Application Developer's Guide - Fundamentals for information about the consequences of the settings of this parameter.