在使用ibatis的时候,to_char(wm_concat())合并行后返回到程序中时,抛异常
ERROR [org.mortbay.log] - <Nested in org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [99999]; error code [22922];
--- The error occurred in sqlmap/embe/areaCoverage/LogisticAreaCoverage.xml.
--- The error occurred while applying a parameter map.
--- Check the areaLogisticAreaCoverage.getAreaCoverageByCityId-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-22922: nonexistent LOB value
; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in sqlmap/embe/areaCoverage/LogisticAreaCoverage.xml.
--- The error occurred while applying a parameter map.
--- Check the areaLogisticAreaCoverage.getAreaCoverageByCityId-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-22922: nonexistent LOB value
:>
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [99999]; error code [22922];
--- The error occurred in sqlmap/embe/areaCoverage/LogisticAreaCoverage.xml.
--- The error occurred while applying a parameter map.
--- Check the areaLogisticAreaCoverage.getAreaCoverageByCityId-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-22922: nonexistent LOB value
; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in sqlmap/embe/areaCoverage/LogisticAreaCoverage.xml.
--- The error occurred while applying a parameter map.
--- Check the areaLogisticAreaCoverage.getAreaCoverageByCityId-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-22922: nonexistent LOB value
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:293)
at xueshenghui.platform.dao.AppAreaCoverageDao.getAreaCoverageByCityId(AppAreaCoverageDao.java:69)
at xueshenghui.platform.service.AppAreaCoverageService.getAreaCoverageByCityId(AppAreaCoverageService.java:99)
at xueshenghui.platform.controller.PfAreaCoverageController.getAreaCoverageByCityId(PfAreaCoverageController.java:85)