An error occured during INSERT: ORA-01465: invalid hex number

[Thangam Mohan]

Hi ,
I am trying to insert a BLOB column from MYSQL database to another BLOB column in Oracle database using BIE Redberri. And I get the following exception

BIE INTERNAL ERROR: java.sql.SQLException: An error occured during INSERT: ORA-01465: invalid hex number

at com.webdeninteractive.bie.commons.relationalxml.Insert.executeInserts(Insert.java:80)
at com.webdeninteractive.bie.commons.relationalxml.Insert.execute(Insert.java:40)
at com.webdeninteractive.xbotts.client.serviceproviders.InsertClient$1.use(InsertClient.java:60)
at com.webdeninteractive.bie.commons.datasource.ConnectionManager.connectUsing(ConnectionManager.java:46)
at com.webdeninteractive.xbotts.client.serviceproviders.InsertClient.runService(InsertClient.java:56)
at com.webdeninteractive.bie.bpm.engine.activity.ActionInstance.sendMessage(ActionInstance.java:265)
at com.webdeninteractive.bie.bpm.engine.activity.ActionInstance.active(ActionInstance.java:126)
at com.webdeninteractive.bie.bpm.engine.activity.AbstractActivityInstance.run(AbstractActivityInstance.java:73)
at com.webdeninteractive.bie.bpm.engine.activity.AbstractActivityInstance.runActivities(AbstractActivityInstance.java:222)
at com.webdeninteractive.bie.bpm.engine.activity.AbstractActivityInstance.runSubActivities(AbstractActivityInstance.java:264)
at com.webdeninteractive.bie.bpm.engine.activity.ActionInstance.receive(ActionInstance.java:166)
at com.webdeninteractive.bie.bpm.engine.dispatcher.JMSEventDispatcher$DispatcherSlave.run(JMSEventDispatcher.java:213)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: ORA-01465: invalid hex number

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:561)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1081)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1548)
at org.jboss.resource.adapter.jdbc.WrappedStatement.execute(WrappedStatement.java:95)
at com.webdeninteractive.bie.commons.relationalxml.XMLStatementBase.insertRow(XMLStatementBase.java:145)
at com.webdeninteractive.bie.commons.relationalxml.Insert.executeInserts(Insert.java:76)

How do I resolve this ?

Thanks and Regards,
Thangam.