Hi Can anybody help
I am running wm 4.0.1
We are inserting records into Oracle database
Before we update we need to concatenate a string so we use a java class
This is the situation:
The Java Class is sending out a String (using a variable called workstring1) of 1500 characters (including spaces between words), this String is causing the Insert to table fail. Although if you hardcode the actual String (“This Text is 1500 chars long……. “) as out put from within the java class, the insert is successful.
The error log shows:
0000010336d61a9a java.sql.SQLExceptionRA-01401: inserted value too large for column
0000010336d61a9a java.sql.SQLExceptionRA-01401: inserted value too large for column
0000010336d61aa9 java.sql.SQLExceptionRA-01401: inserted value too large for column
0000010336d61aa9 java.sql.SQLException: ORA-01401: inserted value too large for column
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java)
at com.wm.app.b2b.server.JDBCConnection.execSQL(JDBCConnection.java:692)
at pub.db.execSQL(db.java:408)
at java.lang.reflect.Method.invoke(Native Method)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:286)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:683)
at com.wm.app.b2b.server.BaseService.invoke(BaseService.java:134)
at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java:247)
at com.wm.lang.flow.FlowState.invokeNode(FlowState.java:458)
at com.wm.lang.flow.FlowState.step(FlowState.java:340)
at com.wm.lang.flow.FlowState.invoke(FlowState.java:308)
at com.wm.app.b2b.server.FlowSvcImpl.baseInvoke(FlowSvcImpl.java:1317)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:683)
at com.wm.app.b2b.server.BaseService.invoke(BaseService.java:134)
at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java:247)
at com.wm.lang.flow.FlowState.invokeNode(FlowState.java:458)
at com.wm.lang.flow.FlowState.step(FlowState.java:340)
at com.wm.lang.flow.FlowState.invoke(FlowState.java:308)
at com.wm.app.b2b.server.FlowSvcImpl.baseInvoke(FlowSvcImpl.java:1317)
at com.wm.app.b2b.server.ServiceManager.i