Forum Stats

  • 3,827,928 Users
  • 2,260,839 Discussions
  • 7,897,408 Comments

Discussions

Question about a LOAD with table with XMLTYPE field

How can I load a table with an XMLTYPE field. When the mapping is executed, it shows me this error 

oracle.odi.runtime.agent.exception.ExecutionEngineException: java.sql.SQLException: Invalid column type: 1111
	at oracle.odi.runtime.agent.execution.sql.SQLCommand.bindResultSetColumns(SQLCommand.java:280)
	at oracle.odi.runtime.agent.execution.sql.SQLCommand.processRecord(SQLCommand.java:171)
	at oracle.odi.runtime.agent.execution.sql.SQLCommand.processRecord(SQLCommand.java:37)
	at oracle.odi.runtime.agent.execution.Executor.performAction(Executor.java:444)
	at oracle.odi.runtime.agent.execution.Executor.handleDataMovementTask(Executor.java:334)
	at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:51)
	at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:206)