My Oracle Support Banner

Mappings / Scenarios Upgraded From ODI 11g Fail With "ODI-1593 : bind parameters ... are not bound to any value" Error When Data Is Read From XML (Doc ID 2282016.1)

Last updated on JANUARY 05, 2018

Applies to:

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


Integration Interfaces / Scenarios that load data from XML do properly function in Oracle Data integrator (ODI) 11g.

Post upgrade to ODI 12c, these Mappings / Scenarios fail with ODI-1593 bind error messages, such as:

oracle.odi.runtime.agent.exception.ExecutionEngineException: ODI-1593: The following bind parameters (xxx) in the task command "insert into XXODI.C$_0xxx............) " are not bound to any value. All the bind parameters should be bound for the command to be successful.
  at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(
  at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(
  at oracle.odi.runtime.agent.execution.Executor.performAction(
  at oracle.odi.runtime.agent.execution.Executor.handleDataMovementTask(
  at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(
  at oracle.odi.runtime.agent.execution.SessionTask.processTask(



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.