Oracle7 Server Distributed Systems Volume II: Replicated Data

Package Variables

Table 12 - 190 describes the package variables that are used by the symmetric replication facility. You may need to check the value of one or more of these variables in your own packages or triggers.

variable type description
schema.rep$what_am_i. i_am_a_snapshot BOOLEAN TRUE indicates that the local site is a snapshot site for the replicated object group. If the local site is a master site for the replicated object group, this variable is FALSE.
dbms_reputil. replication_is_on BOOLEAN TRUE indicates that the generated replication triggers are enabled. FALSE indicates that replication is disabled at the current site for the replicated object group. This variable is set by calling the REPLICATION_ON or REPLICATION_OFF procedures in the DBMS_REPUTIL package.
dbms_reputil. from_remote BOOLEAN This variable is set to TRUE at the beginning of procedures in the $RP replication packages, and is set to FALSE at the end of these procedures. You may need to check this variable if you have any triggers that could be fired as the result of an update by a $RP package.
dbms_reputil. global_name VARCHAR2(128) This variable contains the global database name of the local database.

Table 12 - 190. Replication Package Variables

variable	type	description
`schema`.rep$what_am_i. i_am_a_snapshot	BOOLEAN	TRUE indicates that the local site is a snapshot site for the replicated object group. If the local site is a master site for the replicated object group, this variable is FALSE.
`dbms_reputil. replication_is_on`	BOOLEAN	TRUE indicates that the generated replication triggers are enabled. FALSE indicates that replication is disabled at the current site for the replicated object group. This variable is set by calling the REPLICATION_ON or REPLICATION_OFF procedures in the DBMS_REPUTIL package.
`dbms_reputil. from_remote`	BOOLEAN	This variable is set to TRUE at the beginning of procedures in the $RP replication packages, and is set to FALSE at the end of these procedures. You may need to check this variable if you have any triggers that could be fired as the result of an update by a $RP package.
`dbms_reputil. global_name`	VARCHAR2(128)	This variable contains the global database name of the local database.