Service Problems with SQL

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

The simple question…are you sure that your string from your java service is <1500 characters long?