oracle 跟新字段类型为clob时提示数据库更改的类型无效,WMSYS.WM_CONCAT函数有些版本返回结果为CLOB引起视图无法创建...

在不同版本下查看该函数的返回值类型

10.2.0.5我没有，别的数据基本齐了，结合其他资料，应该是10g的10.2.0.5和11g的11.2.0.3将该函数修改，返回值由varchar2变成了clob，所以在跨越这些版本迁移视图时出现了问题

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production

PL/SQL Release 9.2.0.8.0 - Production

CORE        9.2.0.8.0        Production

TNS for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production

NLSRTL Version 9.2.0.8.0 - Production

SQL> desc WMSYS.WM_CONCAT

Object WMSYS.WM_CONCAT does not exist.

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE        10.2.0.4.0        Production

TNS for Linux: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL> desc WMSYS.WM_CONCAT

Parameter Type     Mode Default?

--------- -------- ---- --------

(RESULT)  VARCHAR2

P1        VARCHAR2 IN

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

PL/SQL Release 11.2.0.1.0 - Production

CORE        11.2.0.1.0        Production

TNS for Linux: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production

SQL> desc WMSYS.WM_CONCAT

Parameter Type     Mode Default?

--------- -------- ---- --------

(RESULT)  VARCHAR2

P1        VARCHAR2 IN

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

CORE        11.2.0.3.0        Production

TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

SQL> desc WMSYS.WM_CONCAT

Parameter Type     Mode Default?

--------- -------- ---- --------

(RESULT)  CLOB

P1        VARCHAR2 IN