My Oracle Support Banner

Procedural Replication with Streams (Doc ID 1079554.1)

Last updated on JANUARY 30, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.4 [Release 10.1 to 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Goal

This is a complete example of simulating Procedure replication using Streams.

PROCEDURE REPLICATION

The ability to replicate the invocation or call of a pl/sql procedure to another database,
rather than the actual DML changes the procedure performed, is known as procedural replication.
This page describes a method of accomplishing procedural replication in a Streams environment.
Procedural replication is simulated in Streams by creating a PL/SQL wrapper procedure and
identifying the procedure to be run in an anonymous block. The wrapper procedure performs
the user procedure to be replicated and generates a DDL statement that will execute the
procedure at the target database. The DDL statement is replicated to the target database
rather than the DML generated by the user procedure. This technique is most useful for
performing large batch updates in Streams using stored procedures.


Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
 PROCEDURE REPLICATION
Solution
 Overview
 Detailed Instructions
 Configuring the Sample Code
 Running the Sample Code
 Sample Code
 Restrictions on Procedural Replication:
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.