My Oracle Support Banner

ODI Error on Loading XML Tables: "java.sql.SQLException: ORA-00926: missing VALUES keyword" (Doc ID 2287052.1)

Last updated on SEPTEMBER 18, 2023

Applies to:

Oracle Data Integrator - Version 11.1.1.6.0 and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.

Symptoms

There is an Oracle Data Integrator (ODI) job that loads data from Oracle tables to XML tables using knowledge modules LKM SQL to SQL and IKM XML Control Append. The XML tables are created in an external database schema using a XML JDBC driver properties parameter to specify the settings file.

When running the job with multiple standalone agents, the below error occurs in the Integration task at the 'Insert new lines' step even though the executed SQL code is correct:

Changes

 

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!

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