My Oracle Support Banner

"ORA-00911: invalid character" Error Received after Upgrading from ODI 11g To ODI 12c when Executing Artifacts that Involve Variables (Doc ID 2419705.1)

Last updated on SEPTEMBER 04, 2020

Applies to:

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


After upgrading from Oracle Data Integrator (ODI) 11g ( and older) to ODI 12c, the Project Variables used inside another Variable are not replaced by their actual value, causing the following error to be received at runtime:

ODI-1228: Task Variable-MY_VARIBLE- fails on the target connection XXXXX.

Caused By: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
  at oracle.odi.runtime.agent.execution.sql.RefreshVariableExecutor.execute(
  at oracle.odi.runtime.agent.execution.sql.RefreshVariableExecutor.execute(
  at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(
  at oracle.odi.runtime.agent.execution.VariableSessionTask.processTask(
  at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(
  at oracle.odi.runtime.agent.execution.VariableSessionTask.doExecuteTask(
  at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(
  at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(
  at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(
  at ...




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
 How to use the "ReplaceVariableNames.groovy"
 Effectively using the script
 Notes - The script might require tuning

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