extractvalue处理XMLTYPE类型超过4000字节ORA-01706的解决方法
发布时间:2020-08-14 15:40:17
来源:ITPUB博客
阅读:226
作者:guocun09
extractvalue在处理XMLTYPE类型运算时非常方便,但在处理超过4000字节column就力不从心了。
问题:
一位朋友在Oracle中使用extractvalue处理XMLTYPE类型时,发现column值超过4000字节时就会报错ORA-01706.
是否真会这样呢?
通过实验重现问题:
1.创建XML table
Create TABLE testxml(
id NUMBER,
data XMLTYPE
);
2.创建目录
CREATE OR REPLACE DIRECTORY
EXPDP_DIR AS
'/data/expdp_dir/';
3.在目录/data/expdp_dir/ 中建立11.xml文件,
模拟Data2长度为4001字节,文件内容如下:
MES
01234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401234012340123401