Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Question about a LOAD with table with XMLTYPE field

User_RFNI8Feb 8 2022

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)

Added on Feb 8 2022

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-standard-edition-one

0 comments

149 views