为何用xml写入中文字符到Clob字段不能正确显示（在线等待）

1. 检查当前XDK版本:

Sqlplus apps/apps
CREATE OR REPLACE FUNCTION XMLVersion RETURN VARCHAR2
IS LANGUAGE JAVA NAME
'oracle.xml.parser.v2.XMLParser.getReleaseVersion() returns java.lang.String';

select xmlversion from dual;

2. 卸载当前的XDK
Sqlplus apps/apps
@/user2/tstdb/8.1.7/oracore/admin/rmxml.sql
Call sys.dbms_java.dropjava('-v rdbms/jlib/xsu12.jar');
Call sys.dbms_java.dropjava('-v xdk/lib/xmlparserv2.jar');
drop package dbms_xmlquery;
drop package dbms_xmlsave;
drop package xmlgen;
drop public synonym dbms_xmlquery;
drop public synonym dbms_xmlsave;
drop public synonym xmlgen;

3. 解压缩xdk_plsql_9_2_0_4_0.tar.gz到/user2/11ipatch/xdkplsql

4. cd /user2/11ipatch/xdkplsql/xdk/admin

5. 编辑xsusyn.sql文件, 将文件中的“ or replace”删除

6. cd /user2/11ipatch/xdkplsql/bin

7. 修改xdkload文件,将:#!/bin/tcsh 修改为 #!/bin/csh

8. 进入c shell: csh

9. ./xdkload -u "sys/change_on_install" -s -dbver 817
注: 运行前检查sys用户密码,可以用svrmgrl进入后运行alter user sys identified by

1<password>命令修改SYS用户密码.   
2  
310\. 用sys用户运行$ORACLE_HOME/rdbms/admin/utlrp.sql   
4  
511\. 运行步骤1中的select xmlversion from dual;检查新版本   
6  
712\. 测试.</password>