38
DBMS_REPUTIL

DBMS_REPUTIL contains subprograms to generate shadow tables, triggers, and packages for table replication, as well as subprograms to generate wrappers for replication of standalone procedure invocations and packaged procedure invocations.

This package is referenced only by the generated code.

Summary of Subprograms

Table 38-1 DBMS_REPUTIL Package Subprograms

REPLICATION_OFF procedure

REPLICATION_ON procedure

REPLICATION_IS_ON 
function

FROM_REMOTE function

GLOBAL_NAME function

REPLICATION_OFF procedure

This procedure modifies tables without replicating the modifications to any other sites in the replicated environment, or disables row-level replication when using procedural replication. In general, you should suspend replication activity for all master groups in your replicated environment before setting this flag.

Syntax

DBMS_REPUTIL.REPLICATION_OFF;

Parameters

None.

REPLICATION_ON procedure

This procedure re-enables replication of changes after replication has been temporarily suspended.

Syntax

DBMS_REPUTIL.REPLICATION_ON;

Parameters

None.

REPLICATION_IS_ON function

This function determines whether or not replication is running. A returned value of TRUE indicates that the generated replication triggers are enabled. FALSE indicates that replication is disabled at the current site for the replicated object group.

The returning value of this function is set by calling the REPLICATION_ON or REPLICATION_OFF procedures in the DBMS_REPUTIL package.

Syntax

DBMS_REPUTIL.REPLICATION_IS_ON
  RETURN BOOLEAN;

Parameters

None.

FROM_REMOTE function

This function returns TRUE at the beginning of procedures in the internal replication packages, and returns FALSE at the end of these procedures. You may need to check this function if you have any triggers that could be fired as the result of an update by an internal package.

Syntax

DBMS_REPUTIL.FROM_REMOTE
   RETURN BOOLEAN;

Parameters

None.

GLOBAL_NAME function

This function determines the global database name of the local database (the global name is the returned value).

Syntax

DBMS_REPUTIL.GLOBAL_NAME
   RETURN VARCHAR2;

Parameters

None.