AnsweredAssumed Answered

When I perform dynamic update to my my database table i get the CLOB errors as below

Question asked by vravi934586 on May 4, 2016
Latest reply on May 10, 2016 by Adam Arrowsmith

java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got CLOB

 

Map has the flat file source and DB target...DB table has some CLOB columns. Whenever I execute the map update always fails with above error while insert always works fine..Why would the insert succeed but the update will fail?

 

To test in the update map I disconnected all the link from source to target for the CLOB columns in DB..But still same error.

 

 

java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got CLOB

 

 

  at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

  at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)

  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)

  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)

  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)

  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)

  at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3476)

  at com.boomi.connector.database.statement.SqlStatement.execute(SqlStatement.java:88)

  at com.boomi.connector.database.executor.SQLWriteExecutor.execute(SQLWriteExecutor.java:62)

  at com.boomi.connector.database.DatabaseSend.executeData(DatabaseSend.java:192)

  at com.boomi.connector.database.DatabaseSend.executeStatement(DatabaseSend.java:144)

  at com.boomi.connector.database.DatabaseSend.executeDocument(DatabaseSend.java:121)

  at com.boomi.connector.database.DatabaseSend.handle(DatabaseSend.java:297)

  at com.boomi.connector.database.DatabaseSend.send(DatabaseSend.java:72)

  at com.boomi.connector.custom.CustomSendConnectorAction.invoke(CustomSendConnectorAction.java:60)

  at com.boomi.connector.base.BaseConnectorAction.invokeBase(BaseConnectorAction.java:275)

  at com.boomi.connector.base.BaseConnectorAction.invoke(BaseConnectorAction.java:214)

  at sun.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:497)

  at com.boomi.util.ClassUtil$InvokerWithClassLoader.invoke(ClassUtil.java:360)

  at com.sun.proxy.$Proxy64.invoke(Unknown Source)

  at com.boomi.process.shape.ConnectorShapeHandler.execute(ConnectorShapeHandler.java:152)

  at com.boomi.process.shape.ConnectorShape.execute(ConnectorShape.java:143)

  at com.boomi.process.graph.ProcessShape.executeShape(ProcessShape.java:550)

  at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:488)

  at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)

  at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:509)

  at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)

  at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:509)

  at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)

  at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:509)

  at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)

  at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:509)

  at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)

  at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:509)

  at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)

  at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:509)

  at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)

  at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:509)

  at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)

  at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:509)

  at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)

  at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:509)

  at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)

  at com.boomi.process.graph.ProcessGraph.execute(ProcessGraph.java:307)

  at com.boomi.process.ProcessExecution.call(ProcessExecution.java:783)

  at com.boomi.execution.ExecutionTask.call(ExecutionTask.java:920)

  at com.boomi.execution.ExecutionTask.call(ExecutionTask.java:63)

  at com.boomi.util.concurrent.CancellableFutureTask.run(CancellableFutureTask.java:172)

  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

  at java.lang.Thread.run(Thread.java:745)

Attachments

Outcomes