Oracle 10g 使用to_char(wm_concat()) 返回到程序中的不是字符串,怎样在数据库中使用sql语句进行类型的转换
在使用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
:>
o
rg.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(AbstractFallbackSQLEx