Replicat Pads Additional Lines Replicating DDLs When DDL Ends With Comments (Doc ID 2275548.1)

Last updated on JUNE 25, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.10 and later
Information in this document applies to any platform.

Symptoms

When DDL ends with a comment Replicat pads additional lines repeating last few lines of the DDL 

create or replace PROCEDURE "PROC_CREATE_DATACUBE_FILES"(
..
END LOOP;
End Proc_Create_Datacube_Files;
-- End B-16213 NULL;
END; <=== ADDITIONAL LINES
END LOOP; <=== ADDITIONAL LINES
End Proc_Create_Datacube_Files; <=== ADDITIONAL LINES
/* GOLDENGATE_DDL_REPLICATION */.

Cause

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