java7update80,12899 : 72000 : java.sql.BatchUpdateException: ORA-12899: value too large f — oracle-t...

Gurus,

I am trying to load data from Source to Target,

Length of TITLE COlumn in source is Varchar2(35) and Target it is Varchar2(80) but i dont why it is creating Varchar2(35) for C$ table and getting the below error.

Please help me

Below is the C$ table script:

create table C$_0WC_PCM_RFI_F

(

C1_RFI_CREATED_DATE_WIDNUMBER(10) NULL,

C2_INTEGRATION_IDVARCHAR2(80) NULL,

C3_RFI_CLOSED_DATE_WIDNUMBER(10) NULL,

C4_RFI_CREATED_DATEDATE NULL,

C5_RFI_CLOSED_DATEDATE NULL,

C6_TITLEVARCHAR2(35) NULL,

C7_PROJECT_NAMEVARCHAR2(8) NULL,

C12_CHANGE_NUMBERVARCHAR2(8) NULL,

C8_CONTRACT_NUMBERVARCHAR2(12) NULL,

C10_CONTRACT_TYPEVARCHAR2(4) NULL,

C9_STATUSVARCHAR2(4) NULL,

C11_APPROVED_COMPANY1VARCHAR2(36) NULL

)

NOLOGGING

I am getting below Error:

12899 : 72000 : java.sql.BatchUpdateException: ORA-12899: value too large for column "BIW_STG_ODI"."C$_0WC_PCM_RFI_F"."C6_TITLE" (actual: 37, maximum: 35)

12899 : 72000 : java.sql.SQLException: ORA-12899: value too large for column "BIW_STG_ODI"."C$_0WC_PCM_RFI_F"."C6_TITLE" (actual: 37, maximum: 35)

java.sql.BatchUpdateException: ORA-12899: value too large for column "BIW_STG_ODI"."C$_0WC_PCM_RFI_F"."C6_TITLE" (actual: 37, maximum: 35)

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:629)

at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9467)

at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:211)

at com.sunopsis.sql.SnpsQuery.executeBatch(SnpsQuery.java:527)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeUpdate(SnpSessTaskSql.java:3038)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execCollOrders(SnpSessTaskSql.java:729)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java:2815)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2515)

at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:534)

at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:449)

at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1954)

at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1818)

at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:559)

at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:224)

at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:481)

at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1040)

at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:114)

at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:93)

at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:84)

at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:49)

at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:502)

at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:454)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)

at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)

at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)

at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)

at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)

at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)

at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)

at org.mortbay.jetty.Server.handle(Server.java:326)

at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)

at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:879)

at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)

at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)

at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)

at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)

at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)