Procedural Replication with Streams (Doc ID 1079554.1)

Last updated on MAY 10, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.4 [Release 10.1 to 10.2]
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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms