Oracle Tips by Burleson

Oracle Streams
Chapter 10 - Streams for Heterogeneous Replication

User Application Enqueue

The following SQL block creates a procedure called LCR_ROW_ON_MKTPRICE:

CREATE OR REPLACE PROCEDURE lcr_row_on_mktprice (
 source_dbname             VARCHAR2,
 cmd_type             VARCHAR2,
 obj_owner             VARCHAR2,
 obj_name             VARCHAR2,
 old_vals             SYS.LCR$_ROW_LIST,
 new_vals             SYS.LCR$_ROW_LIST)
AS
row_lcr                        SYS.LCR$_ROW_RECORD;
BEGIN

--Construct the LCR based on information passed to procedure
row_lcr := SYS.LCR$_ROW_RECORD.CONSTRUCT(
 source_database_name             => source_dbname,
 command_type                         => cmd_type,
 object_owner             => obj_owner,
 object_name                => obj_name,
 old_values                   => old_vals,
 new_values                  => new_vals);