Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Question about a LOAD with table with XMLTYPE field

Question
11
Views
0
Comments
User_RFNI8
User_RFNI8 Rank 1 - Community Starter
edited Aug 13, 2024 3:26PM in Oracle Analytics Cloud and Server 
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)