My Oracle Support Banner

OGG: Azure MS SQL SERVER Data Conversion Issue (Doc ID 2752242.1)

Last updated on JULY 20, 2024

Applies to:

Oracle GoldenGate - Version and later
Information in this document applies to any platform.
From replicate reports, we see that replicate is generating statements properly

DELETE FROM [dbo].[TABLENAME] WHERE [AS_OF] = '2020-12-2400:00:00.000' AND [COL2] = '2985c107ac956e300d4f1e9597fe2cc00b2de850'
Statement length: 143

(S)top display, (K)eep displaying (default): K¿

But on SQL server side, we see gguser running prepare statement , with

exec sp-prepare @p1 output, N¿ @P1, @P2 nvarchar(40)¿ , dbo.TABLENAME where [as of] = @P1 AND [COL2] = @P2¿¿¿


We are seeing the datatype conversion while replicating the data from source ORACLE to MS SQL server database using goldengate.

Source and target key column datatype is VARCHAR2. But , delete statement from replicate shows implicit conversion of key column to NVARCHAR


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

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