My Oracle Support Banner

Error Using ODI JKM Oracle 10g Consistent (Logminer) on Tables with PK Defined on all Columns (Doc ID 578833.1)

Last updated on OCTOBER 31, 2019

Applies to:

Oracle Data Integrator - Version 10.1.3.4.2 and later
Information in this document applies to any platform.

Symptoms

When using the JKM Oracle 10G Consistent Logminer provided by Oracle Data Integrator (ODI) on a table made by columns which are all part of the Primary Key, the "Create View" step generates a wrong code.

For example, if <TABLE> is composed by only two columns (<COL1> and <COL2>) and both of them build the PK, the SQL code generated by ODI contains a comma after the latest column in the Select order, which is syntactically incorrect:

create or replace view <SCHEMA>.JV$<TABLE>
as
select decode(TARG.ROWID, null, 'D', 'I') JRN_FLAG,
       JRN.CDC_TIMESTAMP JRN_DATE, /* For V3 compatibility */
       JRN.CDC_SUBSCRIBER JRN_SUBSCRIBER, /* Renamed for V3 compatibility */
       JRN.<COL1>,
       JRN.<COL2>,
from   <SCHEMA>.<TABLE> JRN

 

Cause

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
Symptoms
Cause
Solution
References

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