Shulou(Shulou.com)06/01 Report--

Different versions of databases directly result in program mapping errors due to inconsistent return types of this function:

1. Error message:

Cause: java.sql.SQLSyntaxErrorException: ORA-01790: expression must have the same data type as the corresponding expression

two。 Compare different versions directly

2.1 10g test is as follows

SELECT*FROM V$VERSION

SELECT WM_CONCAT (T.DNAME) FROM DEPT T

2.2 11g tests are as follows:

3. Fix method "convert using TO_CHAR function"

SELECT TO_CHAR (WM_CONCAT (T.DNAME)) FROM DEPT T select TO_CHAR (SUBSTR (WM_CONCAT (T.DNAME), 1mem2000)) FROM DEPT T

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.