公司oracle升级11G过后，原有的字段插入就不可以了，有谁遇到这种情况了

deliverId  参数名 都没有进行过变更，数据库升级后插入数据就报错
2013-04-16 10:16:30,256 INFO [com.tpaic.callCenter.biz.bo.datainterface.impl.DataFaceBO] - insuranceInfoWriteTaskDto.getBussinessType()=4
2013-04-16 10:16:30,260 INFO [com.tpaic.callCenter.biz.bo.datainterface.impl.DataFaceBO] - 添加日志信息，用于确认缴费过后付费状态投保单号=2401000010513000051缴费方式=1是否付费标示符=1投保单状态=9
2013-04-16 10:16:30,271 INFO [com.tpaic.callCenter.biz.bo.datainterface.impl.DataFaceBO] - updateDeliverForApply.begin:1000105000005576953,time=1366078590271
2013-04-16 10:16:30,277 ERROR [com.tpaic.callCenter.biz.bo.datainterface.impl.DataFaceBO] - 显示UAT信息 deliverId=7284投保单号 applyPolicyNo = 1000105000005576953
2013-04-16 10:16:30,277 ERROR [com.tpaic.callCenter.biz.bo.datainterface.impl.DataFaceBO] - insertDeliverPolicy 显示UAT信息 deliverId=7284投保单号 applyPolicyNo = 1000105000005576953
2013-04-16 10:16:30,277 ERROR [com.tpaic.callCenter.biz.bo.datainterface.impl.DataFaceBO] - insertDeliverPolicy 显示UAT信息 policyMapdeliverId=7284投保单号 applyPolicyNo = 1000105000005576953
2013-04-16 10:16:30,282 ERROR [com.tpaic.callCenter.biz.dao.impl.DataIFaceSqlMapDAO] - excutive sql error:ejb.insertDeliverPolicy
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [17004];  
--- The error occurred in com/tpaic/callCenter/schedule/ibatis/insurance-sync-sql.xml. 
--- The error occurred while applying a parameter map. 
--- Check the ejb.insertDeliverPolicy-InlineParameterMap. 
--- Check the parameter mapping for the 'DELIVERID' property. 
--- Cause: java.sql.SQLException: 无效的列类型; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  
--- The error occurred in com/tpaic/callCenter/schedule/ibatis/insurance-sync-sql.xml. 
--- The error occurred while applying a parameter map. 
--- Check the ejb.insertDeliverPolicy-InlineParameterMap. 
--- Check the parameter mapping for the 'DELIVERID' property. 
--- Cause: java.sql.SQLException: 无效的列类型
Caused by: java.sql.SQLException: 无效的列类型
com.ibatis.common.jdbc.exception.NestedSQLException:  
--- The error occurred in com/tpaic/callCenter/schedule/ibatis/insurance-sync-sql.xml. 
--- The error occurred while applying a parameter map. 
--- Check the ejb.insertDeliverPolicy-InlineParameterMap. 
--- Check the parameter mapping for the 'DELIVERID' property. 
--- Cause: java.sql.SQLException: 无效的列类型
Caused by: java.sql.SQLException: 无效的列类型
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:442)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:81)
at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:305)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:168)
at org.springframework.orm.ibatis.SqlMapClientTemplate.insert(SqlMapClientTemplate.java:303)
at com.tpaic.tpfa.app.persistence.dao.ibatis.BaseDAO.insertOne(BaseDAO.java:176)
at com.tpaic.tpfa.app.persistence.dao.ibatis.BaseDAO.insert(BaseDAO.java:170)
at com.tpaic.callCenter.biz.dao.impl.DataIFaceSqlMapDAO.insertExec(DataIFaceSqlMapDAO.java:22)
at com.tpaic.callCenter.biz.bo.datainterface.impl.DataFaceBO.insertDeliverPolicy(DataFaceBO.java:2430)
at com.tpaic.callCenter.biz.bo.datainterface.impl.DataFaceBO.updateDeliverForApply(DataFaceBO.java:2639)
at com.tpaic.callCenter.biz.bo.datainterface.impl.DataFaceBO.updateWhenState9(DataFaceBO.java:1801)
at com.tpaic.callCenter.biz.bo.datainterface.impl.DataFaceBO.updateInsuranceInfo(DataFaceBO.java:1630)
at com.tpaic.callCenter.biz.bo.datainterface.impl.DataFaceBO.syncInsuranceInfo(DataFaceBO.java:1443)
at com.tpaic.callCenter.biz.service.datainterface.impl.DataIFaceServiceImpl.syncInsuranceInfo(DataIFaceServiceImpl.java:469)
at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:165)
at $Proxy6.syncInsuranceInfo(Unknown Source)
at com.tpaic.callCenter.schedule.InsuranceSyncJobDetail.executive(InsuranceSyncJobDetail.java:44)
at com.tpaic.schedule.biz.service.impl.ScheduleTransactionImp.service(ScheduleTransactionImp.java:96)
at com.tpaic.schedule.biz.service.impl.ScheduleTransactionImp.noTransaction(ScheduleTransactionImp.java:73)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:165)
at $Proxy0.noTransaction(Unknown Source)
at com.tpaic.schedule.biz.service.impl.ScheduleJob.service(ScheduleJob.java:71)
at com.tpaic.schedule.biz.service.impl.ScheduleJob.active(ScheduleJob.java:57)
at com.tpaic.schedule.biz.service.impl.ScheduleJob.execute(ScheduleJob.java:28)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
Caused by: java.sql.SQLException: 无效的列类型
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleStatement.get_internal_type(OracleStatement.java:6164)
at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:1316)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:104)
at com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameter(BasicParameterMap.java:173)
at com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameters(BasicParameterMap.java:125)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:80)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:200)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)
... 34 more

Oracle10g升到11g，wm_concat()返回类型由varchar2变为blob了，你这种情况我就不太清楚了，建议看11g升级指南，特色留意升级变化。

TO_CHAR(）就可以了，但是我个人觉得这种方式可能问题，我用了另一个函数代替的。