December 2002
Intermediate to advanced
928 pages
85h 29m
English
REMOTE_DEPENDENCIES_MODE
Value: TIMESTAMP | SIGNATURE
Default: TIMESTAMP
Specifies how dependencies upon remote stored procedures are to be handled by the database. If set to 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. If set to SIGNATURE, the procedure is allowed to execute as long as the signatures are considered safe, which allows client PL/SQL applications to be run without recompilation.