My Oracle Support Banner

OGG MYSQL Extract Input Value For SQLEXEC Gets Corrupted During Characterset Conversion (Doc ID 2341526.1)

Last updated on JANUARY 11, 2018

Applies to:

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


Oracle GoldenGate Capture for MySQL
Version OGGCORE_12.
Windows x64 (optimized), MySQL Enterprise on Aug 5 2017 07:13:17

table supportdb.source, SQLEXEC (ID lookup, QUERY 'select research_id from lookup where id=?', PARAMS(p1=id),trace all),tokens (tkn_lookup=@GETVAL(lookup.research_id));

| SQLEXEC test2 error (While executing query there was no data found!
Prepared Statement (ID = 1), Query ('select research_id from lookup where id=?')):

2017-11/15 11:16:57.531 main |ERROR| 1125 er/sp.c

| > p1: ¿¿¿¿¿¿¿¿¿¿¿¿¿¿ <========

The INPUT value for SQLEXEC gets corrupted




To view full details, 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 a vibrant support community of peers and Oracle experts.