SQL*Plus: Release 9.2.0.1.0 - Production on 星期日 1月 11 20:45:31 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn scott/tiger@orcl
已连接。
SQL> set serveroutput on
SQL> DECLARE
2 var XMLType;
3 doc DBMS_XMLDOM.DOMDocument;
4 ndoc DBMS_XMLDOM.DOMNode;
5 docelem DBMS_XMLDOM.DOMElement;
6 node DBMS_XMLDOM.DOMNode;
7 childnode DBMS_XMLDOM.DOMNode;
8 nodelist DBMS_XMLDOM.DOMNodelist;
9 buf VARCHAR2(2000);
10 BEGIN
11 var := XMLType('ramesh');
12 -- Create DOMDocument handle
13 doc := DBMS_XMLDOM.newDOMDocument(var);
14 ndoc := DBMS_XMLDOM.makeNode(doc);
15 DBMS_XMLDOM.writeToBuffer(ndoc, buf);
16 DBMS_OUTPUT.put_line('Before:' || buf);
17 docelem := DBMS_XMLDOM.getDocumentElement(doc);
18 -- Access element
19 nodelist := DBMS_XMLDOM.getElementsByTagName(docelem, 'NAME');
20 node := DBMS_XMLDOM.item(nodelist, 0);
21 childnode := DBMS_XMLDOM.getFirstChild(node);
22 -- Manipulate element
23 DBMS_XMLDOM.setNodeValue(childnode, 'raj');
24 DBMS_XMLDOM.writeToBuffer(ndoc, buf);
25 DBMS_OUTPUT.put_line('After:' || buf);
26 DBMS_XMLDOM.freeDocument(doc);
27
28 END;
29 /
Before:?犄??厁??悑?????芿蒑??
After:?犄??????????????
PL/SQL 过程已成功完成。
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
SQL> SHOW PARAMETER NLS_LANGUAGE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_language string AMERICAN
SQL>
这个是在我机器上的运行结果。记得在工作环境上 10g也是这个结果,不知道为什么?