Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

Initialization Parameters, 154 of 188


REMOTE_DEPENDENCIES_MODE

Parameter type: 

String 

Syntax: 

REMOTE_DEPENDENCIES_MODE = {TIMESTAMP | SIGNATURE} 

Parameter class: 

Dynamic. Scope = ALTER SESSION, ALTER SYSTEM. 

Default value: 

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. 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index