My Oracle Support Banner

Procedural Replication with Streams (Doc ID 1079554.1)

Last updated on SEPTEMBER 03, 2021

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.


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


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.


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
 Detailed Instructions
 Configuring the Sample Code
 Running the Sample Code
 Sample Code
 Restrictions on Procedural Replication:

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