GaussDB-DBE_XMLDOM(下) DBE_XMLDOM.GETTAGNAME 返回指定DOMELEMENT的标

DBE_XMLDOM.GETTAGNAME

返回指定DOMELEMENT的标签名称。DBE_XMLDOM.GETTAGNAME的函数原型为：
```
DBE_XMLDOM.GETTAGNAME(
   elem  IN  DOMELEMENT)
RETURN  VARCHAR2;
```
参数描述
elem 指定的DOMELEMENT节点。

示例：

| ``` --创建DOMELEMENT节点后，输出其标签名称。 DECLARE doc dbe_xmldom.domdocument; elem dbe_xmldom.domelement; buffer varchar2(1010); value varchar(1000); BEGIN doc := dbe_xmldom.newDOMDocument(); elem := DBE_XMLDOM.CREATEELEMENT(DBE_XMLDOM.NEWDOMDOCUMENT(), 'root'); value := DBE_XMLDOM.gettagname(elem); dbe_output.print_line('value: '); dbe_output.print_line(value); dbe_xmldom.writetobuffer(doc, buffer); dbe_output.print_line('buffer: '); dbe_output.print_line(buffer); END; / -- 预期结果为： value: root buffer: ANONYMOUS BLOCK EXECUTE
```
| --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
```

参数	描述
elem	指定的DOMELEMENT节点。

DBE_XMLDOM.HASCHILDNODES

检查DOMNODE对象是否拥有任一子节点。DBE_XMLDOM.HASCHILDNODES的函数原型为：
```
DBE_XMLDOM.HASCHILDNODES(
   n  IN  DOMNODE)
RETURN  BOOLEAN;
```
参数描述
n 指定的DOMNODE对象。

示例：

| ``` --创建节点child1并将其挂载到DOC树中，为child1节点添加子节点后，判断其是否拥有任一子节点。 DECLARE doc DBE_XMLDOM.DOMDocument; doc1 DBE_XMLDOM.DOMDocument; root DBE_XMLDOM.DOMElement; child1 DBE_XMLDOM.DOMElement; child2 DBE_XMLDOM.DOMElement; attr DBE_XMLDOM.DOMAttr; text DBE_XMLDOM.DOMTEXT; node DBE_XMLDOM.DOMNode; buf varchar2(1000); BEGIN doc := DBE_XMLDOM.newDOMDocument(); root := DBE_XMLDOM.createElement(doc, 'root'); node := DBE_XMLDOM.appendChild(DBE_xmldom.makeNode(doc),DBE_xmldom.makeNode(root)); child1 := DBE_XMLDOM.createElement(doc, 'child1'); node := DBE_XMLDOM.appendChild(DBE_XMLDOM.makeNode(root), DBE_XMLDOM.makeNode(child1)); child2 := DBE_XMLDOM.createElement(doc, 'child2'); node := DBE_XMLDOM.appendChild(DBE_XMLDOM.makeNode(child1), DBE_XMLDOM.makeNode(child2)); IF DBE_XMLDOM.HASCHILDNODES(DBE_XMLDOM.makeNode(child1)) THEN DBE_OUTPUT.print_line('HAS CHILD NODES'); ELSE DBE_OUTPUT.print_line('NOT HAS CHILD NODES '); END IF; END; / -- 预期结果为： HAS CHILD NODES ANONYMOUS BLOCK EXECUTE
```
| --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
```

参数	描述
n	指定的DOMNODE对象。

DBE_XMLDOM.IMPORTNODE

该函数将节点复制到另一节点中，并将复制后的节点挂载到指定document中。若被复制节点的类型不属于xmldom的constants所规定的12种类型，则直接抛出类型不支持异常。DBE_XMLDOM.IMPORTNODE的函数原型为：

DBE_XMLDOM.IMPORTNODE(
   doc IN DOMDOCUMENT,
   importedNode IN DOMNODE,
   deep IN BOOLEAN)
RETURN DOMNODE;

参数	描述
doc	节点挂载的文档。
importedNode	将要导入的节点。
deep	设置递归导入：- 如果为TRUE，则导入该节点及其所有子节点。

如果为FALSE，则指导入节点本身。 |

示例：

| ``` --获取将DOC2树中的节点root2_node，并将其复制并挂载到DOC树中。 DECLARE doc dbe_xmldom.domdocument; doc2 dbe_xmldom.domdocument; doc_node dbe_xmldom.domnode; doc2_node dbe_xmldom.domnode; root_node dbe_xmldom.domnode; root2_node dbe_xmldom.domnode; import_node dbe_xmldom.domnode; result_node dbe_xmldom.domnode; buffer varchar2(1010); BEGIN doc := dbe_xmldom.newdomdocument(' Everyday Italian Giada De Laurentiis2005 30.00'); doc2 := dbe_xmldom.newdomdocument('LIANLI TU150'); doc_node := DBE_XMLDOM.MAKENODE(doc); doc2_node := DBE_XMLDOM.MAKENODE(doc2); root_node := DBE_XMLDOM.GETFIRSTCHILD(doc_node); root2_node := DBE_XMLDOM.GETFIRSTCHILD(doc2_node); DBE_XMLDOM.WRITETOBUFFER(doc, buffer); dbe_output.print_line(buffer); import_node := DBE_XMLDOM.IMPORTNODE(doc, root2_node, TRUE); result_node := DBE_XMLDOM.APPENDCHILD(root_node, import_node); DBE_XMLDOM.WRITETOBUFFER(doc, buffer); dbe_output.print_line(buffer); END; / -- 预期结果为： Everyday Italian Giada De Laurentiis 2005 30.00 Everyday Italian Giada De Laurentiis 2005 30.00 LIANLI TU150 ANONYMOUS BLOCK EXECUTE

| --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |

DBE_XMLDOM.ISNULL

检测给定的DOMATTR类型节点是否为NULL。如果是返回TRUE，否则返回FALSE。DBE_XMLDOM.ISNULL的函数原型为：

DBE_XMLDOM.ISNULL(
   a       IN     DOMATTR)
RETURN BOOLEAN;

检测给定的DOMDOCUMENT类型节点是否为NULL。如果是返回TRUE，否则返回FALSE。DBE_XMLDOM.ISNULL的函数原型为：

DBE_XMLDOM.ISNULL(
   doc       IN     DOMDOCUMENT)
RETURN BOOLEAN;

检测给定的DOMELEMENT类型节点是否为NULL。如果是返回TRUE，否则返回FALSE。DBE_XMLDOM.ISNULL的函数原型为：

DBE_XMLDOM.ISNULL(
   elem     IN     DOMELEMENT)
RETURN BOOLEAN;

检测给定的DOMNAMEDNODEMAP类型节点是否为NULL。如果是返回TRUE，否则返回FALSE。DBE_XMLDOM.ISNULL的函数原型为：

DBE_XMLDOM.ISNULL(
   nnm       IN     DOMNAMEDNODEMAP)
RETURN BOOLEAN;

检测给定的DOMNODE类型节点是否为NULL。如果是返回TRUE，否则返回FALSE。DBE_XMLDOM.ISNULL的函数原型为：

DBE_XMLDOM.ISNULL(
   n      IN     DOMNODE)
RETURN BOOLEAN;

检测给定的DOMNODELIST类型节点是否为NULL。如果是返回TRUE，否则返回FALSE。DBE_XMLDOM.ISNULL的函数原型为：

DBE_XMLDOM.ISNULL(
   nl       IN     DOMNODELIST)
RETURN BOOLEAN;

检测给定的DOMTEXT类型节点是否为NULL。如果是返回TRUE，否则返回FALSE。DBE_XMLDOM.ISNULL的函数原型为：

DBE_XMLDOM.ISNULL(
   t       IN     DOMTEXT)
RETURN BOOLEAN;

参数	描述
a	指定的DOMATTR类型节点。
doc	指定的DOMDOCUMENT类型节点。
elem	指定的DOMELEMENT类型节点。
nnm	指定的DOMNAMEDNODEMAP类型节点。
n	指定的DOMNODE类型节点。
nl	指定的DOMNODELIST类型节点。
t	指定的DOMTEXT类型节点。

由于DBE_XMLDOM.FREEDOCUMENT的实现差异，DBE_XMLDOM.ISNULL接口在调用释放后的DOMDOCUMENT节点时会发生报错。

示例：

| ``` --1. 通过createAttribute创建DOMATTR节点，并判断其是否为空。 DECLARE doc DBE_XMLDOM.DOMDocument; attr DBE_XMLDOM.DOMATTR; buf VARCHAR2(1000); BEGIN doc := DBE_xmldom.newdomdocument(' ]> 中文 Jani Reminder Don''t forget me this weekend! '); attr := DBE_XMLDOM.CREATEATTRIBUTE (doc, 'length'); if DBE_XMLDOM.ISNULL(attr) then DBE_OUTPUT.print_line('null'); else DBE_OUTPUT.print_line('not null'); end if; END; / -- 预期结果为： not null ANONYMOUS BLOCK EXECUTE --2. DOMELEMENT仅声明不初始化，并判断其是否为空。 DECLARE docelem DBE_XMLDOM.DOMElement; BEGIN if DBE_XMLDOM.ISNULL(docelem) then DBE_OUTPUT.print_line('null'); else DBE_OUTPUT.print_line('not null'); end if; END; / -- 预期结果为： null ANONYMOUS BLOCK EXECUTE --3. 通过newDomdocument构建良构的DOMDOCUMENT节点，判断其是否为空。 Declare doc dbe_xmldom.domdocument; BEGIN doc := DBE_xmldom.newdomdocument(' ]> 中文 Jani Reminder Don''t forget me this weekend! '); if DBE_XMLDOM.ISNULL(doc) then DBE_OUTPUT.print_line('null'); else DBE_OUTPUT.print_line('not null'); end if; END; / -- 预期结果为： not null ANONYMOUS BLOCK EXECUTE

| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |

DBE_XMLDOM.ITEM

根据索引返回list中与索引对应的元素。DBE_XMLDOM.ITEM的函数原型为：

DBE_XMLDOM.ITEM(
   nl IN DOMNODELIST,
   index IN NUMBER)
RETURN DOMNODE;

根据索引返回map中与索引对应的元素。DBE_XMLDOM.ITEM的函数原型为：

DBE_XMLDOM.ITEM(
   nnm IN DOMNAMEDNODEMAP,
   index IN NUMBER)
RETURN DOMNODE;

参数	描述
nl	DOMNODELIST。
nnm	DOMNAMEDNODEMAP。
index	要检索的元素的索引。

map类型函数item对不合理的参数输入：如bool、clob，会默认指向第一个index的值。

示例：

| ``` --1. 根据索引返回map中与索引对应的元素。 DECLARE doc DBE_XMLDOM.DOMDocument; elem DBE_XMLDOM.DOMElement; map DBE_XMLDOM.DOMNAMEDNODEMAP; node DBE_XMLDOM.DOMNODE; node2 DBE_XMLDOM.DOMNODE; buf varchar2(1000); BEGIN doc := dbe_xmldom.newdomdocument(' Everyday ItalianGiada De Laurentiis 200530.00'); elem := DBE_XMLDOM.GETDOCUMENTELEMENT(doc); node := DBE_XMLDOM.MAKENODE(elem); map := DBE_XMLDOM.GETATTRIBUTES(DBE_XMLDOM.getFirstChild(node)); node2:= DBE_XMLDOM.item(map,0); DBE_XMLDOM.writeToBuffer(node2, buf); dbe_output.print_line(buf); dbe_xmldom.freedocument(doc); RAISE NOTICE '%', buf; END; / -- 预期结果为： cooking NOTICE: cooking ANONYMOUS BLOCK EXECUTE --2. 根据索引返回list中与索引对应的元素。 DECLARE doc dbe_xmldom.domdocument; node dbe_xmldom.domnode; node1 dbe_xmldom.domnode; nodelist DBE_XMLDOM.DOMNODELIST; len INTEGER; buffer1 varchar2(1010); BEGIN doc := dbe_xmldom.newdomdocument(' Everyday ItalianGiada De Laurentiis 200530.00'); node := dbe_xmldom.makenode(doc); node := dbe_xmldom.GETFIRSTCHILD(node); node := dbe_xmldom.GETFIRSTCHILD(node); nodelist := DBE_XMLDOM.GETCHILDNODES(node); len := DBE_XMLDOM.GETLENGTH(nodelist); RAISE NOTICE 'len : %', len; node1 := DBE_XMLDOM.ITEM(nodelist, 0); IF DBE_XMLDOM.ISNULL(node1) THEN dbe_output.print_line('IS NULL'); ELSE dbe_output.print_line('NOT NULL'); END IF; dbe_xmldom.writetobuffer(node1, buffer1); dbe_output.print_line('buffer1: '); dbe_output.print_line(buffer1); END; / -- 预期结果为： NOTICE: len : 4 NOT NULL buffer1: Everyday Italian ANONYMOUS BLOCK EXECUTE

| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |

DBE_XMLDOM.MAKEELEMENT

返回转换后的DOMELEMENT对象。DBE_XMLDOM.MAKEELEMENT的函数原型为：
```
DBE_XMLDOM.MAKEELEMENT(
   n IN DOMNODE)
RETURN DOMELEMENT;
```
参数描述
n 指定的DOMNODE对象。

示例：

| ``` --将DOMELEMENT类型转换后的DOMNODE类型节点node强制转换回DOMELEMENT类型。 DECLARE buf VARCHAR2(1000); doc DBE_XMLDOM.DOMDocument; elem DBE_XMLDOM.DOMElement; elem2 DBE_XMLDOM.DOMElement; node DBE_XMLDOM.DOMNode; BEGIN doc := DBE_XMLDOM.NEWDOMDOCUMENT(); elem := DBE_XMLDOM.createElement(doc, 'aaa'); node := DBE_XMLDOM.makeNode(elem); elem2 := DBE_XMLDOM.makeElement(node); buf := DBE_XMLDOM.GETNODENAME(DBE_XMLDOM.makeNode(elem2)); DBE_OUTPUT.print_line(buf); END; / -- 预期结果为： aaa ANONYMOUS BLOCK EXECUTE
```
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
```

参数	描述
n	指定的DOMNODE对象。

DBE_XMLDOM.MAKENODE

将给定的DOMATTR类型节点强制转换为DOMNODE类型，返回DOMNODE节点。DBE_XMLDOM.MAKENODE的函数原型为：

DBE_XMLDOM.MAKENODE(
   a        IN     DOMATTR)
 RETURN DOMNODE;

将给定的DOMDOCUMENT类型节点强制转换为DOMNODE类型，返回DOMNODE节点。DBE_XMLDOM.MAKENODE的函数原型为：

DBE_XMLDOM.MAKENODE(
   doc      IN     DOMDOCUMENT)
 RETURN DOMNODE;

将给定的DOMELEMENT类型节点强制转换为DOMNODE类型，返回DOMNODE节点。DBE_XMLDOM.MAKENODE的函数原型为：

DBE_XMLDOM.MAKENODE(
   elem       IN     DOMELEMENT)
 RETURN DOMNODE;

将给定的DOMTEXT类型节点强制转换为DOMNODE类型，返回DOMNODE节点。DBE_XMLDOM.MAKENODE的函数原型为：

DBE_XMLDOM.MAKENODE(
   t       IN     DOMTEXT)
 RETURN DOMNODE;

参数	描述
a	指定的DOMATTR类型节点。
doc	指定的DOMDOCUMENT类型节点。
elem	指定的DOMELEMENT类型节点。
t	指定的DOMTEXT类型节点。

由于语法限制，DBE_XMLDOM.MAKENODE作为函数返回值时，不能直接通过如下命令实现：

return DBE_XMLDOM.MAKENODE(doc);

建议写为：

tmp_node := DBE_XMLDOM.MAKENODE(doc );
return tmp_node;

示例：

| ``` --1. createattr生成ATTR,将其转换为node。 DECLARE doc DBE_XMLDOM.DOMDocument; attr DBE_XMLDOM.DOMATTR; dom_node DBE_XMLDOM.DOMNode; buf VARCHAR2(1000); BEGIN doc := DBE_xmldom.newdomdocument(' ]> 中文 Jani Reminder Don''t forget me this weekend! '); attr := DBE_XMLDOM.CREATEATTRIBUTE (doc, 'length'); dom_node := DBE_XMLDOM.makeNode(attr); buf := DBE_XMLDOM.getNodeName(dom_node); DBE_OUTPUT.print_line(buf); END; / -- 预期结果为： length ANONYMOUS BLOCK EXECUTE --2. getdocumentelement函数生成elem节点后进行makenode。 DECLARE doc DBE_XMLDOM.DOMDocument; root DBE_XMLDOM.DOMElement; attr DBE_XMLDOM.DOMATTR; node DBE_XMLDOM.DOMNODE; buf VARCHAR2(1000); BEGIN doc := DBE_xmldom.newdomdocument(' ]> 中文 Jani Reminder Don''t forget me this weekend! '); root := DBE_XMLDOM.getDocumentElement(doc); node := DBE_XMLDOM.makenode(root); DBE_OUTPUT.print_line(DBE_XMLDOM.GETNODENAME(node)); END; / -- 预期结果为： note ANONYMOUS BLOCK EXECUTE --3. 通过newdomdocument创建DOMDOCUMENT类型参数，非空内容，并作为MAKENODE的输入参数。 DECLARE doc DBE_XMLDOM.DOMDocument; buf VARCHAR2(1000); dom_node DBE_XMLDOM.DOMNODE; BEGIN doc := DBE_xmldom.newdomdocument(' ]> 中文 Jani Reminder Don''t forget me this weekend! '); DBE_OUTPUT.print_line('doc.id: '); DBE_OUTPUT.print_line(doc.id); dom_node := DBE_XMLDOM.makeNode(doc); DBE_OUTPUT.print_line('dom_node.id: '); DBE_OUTPUT.print_line(dom_node.id); buf := DBE_XMLDOM.GETNODENAME(dom_node); DBE_OUTPUT.print_line(buf); END; / -- 预期结果为： doc.id: 19000000000000001B00000001 dom_node.id: 19000000010000001B00000001 #document ANONYMOUS BLOCK EXECUTE --4. DOMTEXT声明变量，不初始化, 并作为MAKENODE的输入参数。 DECLARE text DBE_XMLDOM.DOMTEXT; buf VARCHAR2(1000); dom_node DBE_XMLDOM.DOMNODE; BEGIN dom_node := DBE_XMLDOM.makeNode(text); buf := DBE_XMLDOM.GETNODENAME(dom_node); DBE_OUTPUT.print_line(buf); END; / -- 预期结果为： ANONYMOUS BLOCK EXECUTE

| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |

DBE_XMLDOM.NEWDOMDOCUMENT

返回新的DOMDOCUMENT对象。DBE_XMLDOM.NEWDOMDOCUMENT的函数原型为：
```
DBE_XMLDOM.NEWDOMDOCUMENT
RETURN DOMDOCUMENT;
```
返回从指定的XMLType类型创建的新DOMDOCUMENT实例对象。DBE_XMLDOM.NEWDOMDOCUMENT的函数原型为：
```
DBE_XMLDOM.NEWDOMDOCUMENT(
   xmldoc    IN SYS.XMLTYPE)
RETURN DOMDOCUMENT;
```
返回从指定的CLOB类型创建的新DOMDOCUMENT实例对象。DBE_XMLDOM.NEWDOMDOCUMENT的函数原型为
```
DBE_XMLDOM.NEWDOMDOCUMENT(
   cl       IN    CLOB)
RETURN DOMDOCUMENT;
```
参数描述
xmldoc 指定的XMLType类型。
cl 指定的CLOB类型。
- 入参大小需限制在1GB以内。
- 目前暂不支持外部DTD解析。
- newdomdocument创建的doc，默认UTF-8字符集。
- 从同一个xmltype实例中解析出的每一个doc都是独立的，对doc的修改也不会影响到xmltype。
- 与ORA数据库差异参见DBE_XMLPARSER.PARSECLOB。
示例：

| ``` --1. 返回新的DOMDOCUMENT对象。 DECLARE doc dbe_xmldom.domdocument; buffer varchar2(1010); BEGIN doc := dbe_xmldom.newdomdocument(); dbe_xmldom.setdoctype(doc, 'note', 'sysid', 'pubid'); dbe_xmldom.writetobuffer(doc, buffer); dbe_output.print_line('buffer: '); dbe_output.print_line(buffer); dbe_xmldom.freedocument(doc); END; / -- 预期结果为： buffer: ANONYMOUS BLOCK EXECUTE --2. 返回从指定的CLOB类型创建的新DOMDOCUMENT实例对象。 DECLARE doc dbe_xmldom.domdocument; buffer varchar2(1010); BEGIN doc := dbe_xmldom.newdomdocument(' testJaniReminder Don''t forget me this weekend!'); dbe_xmldom.writetobuffer(doc, buffer); dbe_output.print_line('buffer: '); dbe_output.print_line(buffer); dbe_xmldom.freedocument(doc); END; / -- 预期结果为： buffer: test Jani Reminder Don't forget me this weekend! ANONYMOUS BLOCK EXECUTE --3. 返回从指定的XMLType类型创建的新DOMDOCUMENT实例对象。 DECLARE doc dbe_xmldom.domdocument; xt xmltype; buffer varchar2(1010); BEGIN xt := xmltype('<h:data xmlns:h="www.w3.org/TR/html4/"> <h:da1 len="10">test namespace</h:da1> <h:da1>bbbbbbbbbb</h:da1> </h:data>'); doc := dbe_xmldom.newdomdocument(xt); dbe_xmldom.writetobuffer(doc, buffer); dbe_output.print_line('buffer: '); dbe_output.print_line(buffer); dbe_xmldom.freedocument(doc); END; / -- 预期结果为： buffer: <h:data xmlns:h="www.w3.org/TR/html4/"> <h:da1 len="10">test namespace</h:da1> <h:da1>bbbbbbbbbb</h:da1> </h:data> ANONYMOUS BLOCK EXECUTE
```
| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
```

参数	描述
xmldoc	指定的XMLType类型。
cl	指定的CLOB类型。

DBE_XMLDOM.SETATTRIBUTE

按名称设置DOMELEMENT属性的值。DBE_XMLDOM.SETATTRIBUTE的函数原型为：
```
DBE_XMLDOM.SETATTRIBUTE(
   elem    IN  DOMELEMENT,
   name    IN  VARCHAR2,
   value   IN  VARCHAR2);
```
按名称和命名空间URI设置DOMELEMENT属性的值。DBE_XMLDOM.SETATTRIBUTE的函数原型为：
```
DBE_XMLDOM.SETATTRIBUTE(
   elem    IN  DOMELEMENT,
   name    IN  VARCHAR2,
   value   IN  VARCHAR2,
   ns      IN  VARCHAR2);
```
参数描述
elem 指定的DOMELEMENT节点。
name 属性名称。
value 属性值。
ns 命名空间。

DBE_XMLDOM.SETATTRIBUTE接口可以添加多个属性，属性名称不可以为null，且同一个DOMELEMENT节点不能出现同名属性。如需添加同名属性，应显式的为每个同名属性设置命名空间，但是应尽量避免此类操作。如果属性存在于某命名空间下，当修改属性时，应显示指定命名空间，否则视为添加同名属性。

示例：

| ``` --1. 按名称设置DOMELEMENT属性的值。 DECLARE doc dbe_xmldom.domdocument; elem dbe_xmldom.domelement; docnode DBE_XMLDOM.DOMNode; buffer varchar2(1010); value varchar(1000); BEGIN doc := dbe_xmldom.newDOMDocument(); elem := DBE_XMLDOM.CREATEELEMENT(doc, 'root'); DBE_XMLDOM.setattribute(elem, 'len', '50cm'); docnode := DBE_XMLDOM.appendChild(DBE_XMLDOM.makeNode(doc), DBE_XMLDOM.makeNode(elem)); dbe_xmldom.writetobuffer(doc, buffer); dbe_output.print_line('buffer: '); dbe_output.print_line(buffer); END; / -- 预期结果为： buffer: ANONYMOUS BLOCK EXECUTE --2. 按名称和命名空间URI设置DOMELEMENT属性的值。 DECLARE doc dbe_xmldom.domdocument; elem dbe_xmldom.domelement; docnode DBE_XMLDOM.DOMNode; buffer varchar2(1010); value varchar(1000); begin doc := dbe_xmldom.newDOMDocument(); elem := DBE_XMLDOM.CREATEELEMENT(doc, 'root'); DBE_XMLDOM.setattribute(elem, 'len', '50cm', 'www.huawei.com'); docnode := DBE_XMLDOM.appendChild(DBE_XMLDOM.makeNode(doc), DBE_XMLDOM.makeNode(elem)); dbe_xmldom.writetobuffer(doc, buffer); dbe_output.print_line('buffer: '); dbe_output.print_line(buffer); END; / -- 预期结果为： buffer: ANONYMOUS BLOCK EXECUTE --3. 按名称修改DOMELEMENT属性的值。 DECLARE doc dbe_xmldom.domdocument; elem dbe_xmldom.domelement; docnode DBE_XMLDOM.DOMNode; buffer varchar2(1010); value varchar(1000); BEGIN doc := dbe_xmldom.newDOMDocument(); elem := DBE_XMLDOM.CREATEELEMENT(doc, 'root'); DBE_XMLDOM.setattribute(elem, 'len', '50cm'); DBE_XMLDOM.setattribute(elem, 'len', '55cm'); docnode := DBE_XMLDOM.appendChild(DBE_XMLDOM.makeNode(doc), DBE_XMLDOM.makeNode(elem)); dbe_xmldom.writetobuffer(doc, buffer); dbe_output.print_line('buffer: '); dbe_output.print_line(buffer); END; / -- 预期结果为： buffer: ANONYMOUS BLOCK EXECUTE --4. 按名称和命名空间URI修改DOMELEMENT属性的值。 DECLARE doc dbe_xmldom.domdocument; elem dbe_xmldom.domelement; docnode DBE_XMLDOM.DOMNode; buffer varchar2(1010); value varchar(1000); begin doc := dbe_xmldom.newDOMDocument(); elem := DBE_XMLDOM.CREATEELEMENT(doc, 'root'); DBE_XMLDOM.setattribute(elem, 'len', '50cm', 'www.huawei.com'); DBE_XMLDOM.setattribute(elem, 'len', '55cm', 'www.huawei.com'); docnode := DBE_XMLDOM.appendChild(DBE_XMLDOM.makeNode(doc), DBE_XMLDOM.makeNode(elem)); dbe_xmldom.writetobuffer(doc, buffer); dbe_output.print_line('buffer: '); dbe_output.print_line(buffer); END; / -- 预期结果为： buffer: ANONYMOUS BLOCK EXECUTE
```
| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
```

参数	描述
elem	指定的DOMELEMENT节点。
name	属性名称。
value	属性值。
ns	命名空间。

DBE_XMLDOM.SETCHARSET

设置DOMDOCUMENT的CHATSET字符集。DBE_XMLDOM.SETCHARSET的函数原型为：

DBE_XMLDOM.SETCHARSET(
   doc       IN     DOMDocument,
   charset   IN     VARCHAR2);

参数	描述
doc	指定的DOMDOCUMENT节点
charset	字符集

charset限制为60个字节以内。
目前支持的字符集有：UTF-8、UTF-16、UCS-4、UCS-2、ISO-8859-1、ISO-8859-2、ISO-8859-3、ISO-8859-4、ISO-8859-5、ISO-8859-6、ISO-8859-7、ISO-8859-8、ISO-8859-9、ISO-2022-JP、Shift_JIS、EUC-JP、ASCII。输入其他字符集会报错或者可能导致输出乱码。

示例：

| ``` --为DOC树设置UTF-16字符集后，将DOC树输出到缓冲区。 DECLARE doc dbe_xmldom.domdocument; buffer varchar2(1010); BEGIN doc := dbe_xmldom.newdomdocument(' ]> testJaniReminder Don''t forget me this weekend!'); dbe_xmldom.setcharset(doc, 'utf-16'); dbe_xmldom.writetobuffer(doc, buffer); dbe_output.print_line('buffer: '); dbe_output.print_line(buffer); dbe_xmldom.freedocument(doc); END; / -- 预期结果为： buffer: ]> test Jani Reminder Don't forget me this weekend! ANONYMOUS BLOCK EXECUTE

| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |

DBE_XMLDOM.SETDOCTYPE

设置DOMDOCUMENT的外部DTD。DBE_XMLDOM.SETDOCTYPE的函数原型为：

DBE_XMLDOM.SETDOCTYPE(
  doc     IN   DOMDocument, 
  name    IN   VARCHAR2,
  sysid   IN   VARCHAR2, 
  pubid   IN   VARCHAR2);

参数	描述
doc	指定的DOMDOCUMENT节点。
name	需要初始化doctype的名称。
sysid	需要初始化doctype的system ID。
pubid	需要初始化doctype的public ID。

name、sysid、pubid的总长度限制在32500个字节以内。

示例：

| ``` --为DOMDOCUMENT的外部DTD分别设置初始化的system ID、public ID和名称后，分别将每次修改后的DOC树输出到缓冲区。 DECLARE doc dbe_xmldom.domdocument; buffer varchar2(1010); begin doc := dbe_xmldom.newdomdocument(' ]> testJaniReminder Don''t forget me this weekend!'); dbe_xmldom.setdoctype(doc, 'note', 'sysid', 'pubid'); dbe_xmldom.writetobuffer(doc, buffer); dbe_output.print_line('buffer: '); dbe_output.print_line(buffer); dbe_output.print_line('------------------------------------------------'); dbe_xmldom.setdoctype(doc, 'n0te', NULL, ''); dbe_xmldom.setdoctype(doc, 'n0t1e', NULL, ''); dbe_xmldom.writetobuffer(doc, buffer); dbe_output.print_line('buffer: '); dbe_output.print_line(buffer); dbe_xmldom.freedocument(doc); END; / -- 预期结果为： buffer: ]> test Jani Reminder Don't forget me this weekend! ------------------------------------------------ buffer: ]> test Jani Reminder Don't forget me this weekend! ANONYMOUS BLOCK EXECUTE

| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |

DBE_XMLDOM.SETNODEVALUE

此函数用于向DOMNODE对象中设置节点的值。DBE_XMLDOM.SETNODEVALUE的函数原型为：
```
DBE_XMLDOM.SETNODEVALUE(
 n IN DOMNODE,
 nodeValue IN VARCHAR2);
```
参数描述
n 指定的DOMNODE对象。
nodeValue 向DOMNODE对象中设置的字符串。
1. nodeValue可以输入空字符串和NULL值，但不会对节点值进行修改。
2. nodeValue暂不支持转义字符'&'，如字符串中包含该转义字符，会清空节点值。
3. nodeValue默认的最大长度受限于VARCHAR2类型，为32767字节，超过该长度会抛出异常。
示例：

| ``` --对DOMTEXT转换后的DOMNODE节点设置与初始值不同的节点值后，获取并输出该节点的值。 DECLARE buf VARCHAR2(1000); doc DBE_XMLDOM.DOMDocument; text DBE_XMLDOM.DOMText; elem2 DBE_XMLDOM.DOMElement; node DBE_XMLDOM.DOMNode; BEGIN doc := DBE_XMLDOM.NEWDOMDOCUMENT(); text := DBE_XMLDOM.createTextNode(doc, 'aaa'); DBE_XMLDOM.SETNODEVALUE(DBE_XMLDOM.makeNode(text), 'ccc'); buf := DBE_XMLDOM.GETNODEVALUE(DBE_XMLDOM.makeNode(text)); DBE_OUTPUT.print_line(buf); END; / -- 预期结果为： ccc ANONYMOUS BLOCK EXECUTE
```
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
```

参数	描述
n	指定的DOMNODE对象。
nodeValue	向DOMNODE对象中设置的字符串。

DBE_XMLDOM.WRITETOBUFFER

使用数据库字符集将 XML 节点写入指定缓冲区。DBE_XMLDOM.WRITETOBUFFER的函数原型为：

DBE_XMLDOM.WRITETOBUFFER( 
   doc       IN      DOMDOCUMENT, 
   buffer   INOUT  VARCHAR2);

使用数据库字符集将 XML 文档写入指定缓冲区。DBE_XMLDOM.WRITETOBUFFER的函数原型为：

DBE_XMLDOM.WRITETOBUFFER( 
   n        IN      DOMNODE, 
   buffer   INOUT  VARCHAR2);

参数	描述
doc	指定的DOMDOCUMENT节点。
buffer	写入操作的缓冲区。
n	指定的DOMNODE节点。

writetobuffer输出buffer限制在1GB以内。
该函数会添加缩进等内容，将输出格式化。输出doc将包含XML声明version和encoding。
默认以UTF-8字符集输出xml。

示例：

| ``` --1. 输入DOMNODE类型参数。 DECLARE doc dbe_xmldom.domdocument; elem DBE_XMLDOM.DOMELEMENT; buf varchar2(1000); BEGIN doc := dbe_xmldom.newdomdocument(); elem := dbe_xmldom.createelement(doc,'elem'); DBE_XMLDOM.WRITETOBUFFER(dbe_xmldom.makenode(elem), buf); DBE_OUTPUT.print_line(buf); END; / -- 预期结果为： ANONYMOUS BLOCK EXECUTE --2. 输入DOMDOCUMENT类型参数。 DECLARE doc DBE_XMLDOM.DOMDocument; buf VARCHAR2(1000); BEGIN doc := dbe_xmldom.newdomdocument(' ]> testJaniReminder Don''t forget me this weekend!'); DBE_XMLDOM.WRITETOBUFFER(doc, buf); DBE_OUTPUT.print_line('doc: '); DBE_OUTPUT.print_line(buf); DBE_XMLDOM.FREEDOCUMENT(doc); END; / -- 预期结果为： doc: ]> test Jani Reminder Don't forget me this weekend! ANONYMOUS BLOCK EXECUTE

| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |

DBE_XMLDOM.WRITETOCLOB

使用数据库字符集将 XML 节点写入指定的 CLOB。DBE_XMLDOM.WRITETOCLOB的函数原型为：

DBE_XMLDOM.WRITETOCLOB(
   doc     IN      DOMDOCUMENT,  
   cl      INOUT  CLOB);

使用数据库字符集将 XML 节点写入指定的 CLOB。DBE_XMLDOM.WRITETOCLOB的函数原型为：

DBE_XMLDOM.WRITETOCLOB(
   n       IN      DOMNODE, 
   cl      INOUT  CLOB);

参数	描述
doc	指定的DOMDOCUMENT节点。
cl	要写入的CLOB。
n	指定的DOMNODE节点。

document入参，writetoclob大小支持1GB以内。
该函数会添加缩进等内容，将输出格式化。输出doc将包含XML声明version和encoding。
默认以UTF-8字符集输出xml。

示例：

| ``` --1. 输入DOMNODE类型参数。 DECLARE CL CLOB; N DBE_XMLDOM.DOMNODE; BEGIN DBE_XMLDOM.WRITETOCLOB(N, CL); DBE_OUTPUT.PRINT_LINE(CL); END; / -- 预期结果为： ANONYMOUS BLOCK EXECUTE --2. 输入DOMDOCUMENT类型参数。 DECLARE doc dbe_xmldom.domdocument; mclob clob; BEGIN doc := dbe_xmldom.newdomdocument(' ]> testJaniReminder Don''t forget me this weekend!'); dbe_xmldom.writetoclob(doc, mclob); dbe_output.print_line('mclob: '); dbe_output.print_line(mclob); dbe_xmldom.freedocument(doc); END; / -- 预期结果为： mclob: ]> test Jani Reminder Don't forget me this weekend! ANONYMOUS BLOCK EXECUTE

| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |

DBE_XMLDOM.WRITETOFILE

使用数据库字符集将 XML 节点写入指定文件。DBE_XMLDOM.WRITETOFILE的函数原型为：
```
DBE_XMLDOM.WRITETOCLOB(
   doc     IN      DOMDOCUMENT,  
   fileName   IN      VARCHAR2);
```
使用数据库字符集将 XML 节点写入指定文件。DBE_XMLDOM.WRITETOFILE的函数原型为：
```
DBE_XMLDOM.WRITETOCLOB(
   n       IN      DOMNODE, 
   fileName   IN      VARCHAR2);
```
使用指定字符集将 XML 文档写入指定文件。DBE_XMLDOM.WRITETOFILE的函数原型为：
```
DBE_XMLDOM.WRITETOCLOB(
   doc     IN      DOMDOCUMENT,  
   fileName   IN      VARCHAR2,
   charset   IN   VARCHAR2);
```
使用指定字符集将 XML 文档写入指定文件。DBE_XMLDOM.WRITETOFILE的函数原型为：
```
DBE_XMLDOM.WRITETOCLOB(
   n       IN      DOMNODE, 
   fileName   IN      VARCHAR2,
   charset   IN   VARCHAR2);
```
参数描述
doc 指定的DOMDOCUMENT节点。
fileName 要写入的文件。
n 指定的DOMNODE节点。
charset 指定字符集。
- document入参，filename长度限制在255个字节以内，charset限制在60个字节以内，charset支持字符集请参考DBE_XMLDOM.SETCHARSET接口。
- 该函数会添加缩进等内容，将输出格式化。输出doc将包含XML声明version和encoding。
- 传入newdomdocument()无参创建的doc，在不指定charset时不会报错，默认UTF-8字符集。
- filename需要在pg_directory中创建的路径下，filename中的\会被转换成/，只允许存在一个/。文件名格式应为pg_directory_name/file_name.xml，输出文件仅支持xml类型。
- 在打开guc参数safe_data_path时，用户只能通过高级包读写safe_data_path指定文件路径下的文件。
- 创建目录前需要保证路径为操作系统实际存在的路径，且用户需要拥有该目录的读和写权限。关于目录创建，请参考CREATE DIRECTORY。
示例：

| ``` --创建目录前需要保证路径为操作系统实际存在的路径，且用户需要拥有该目录的读和写权限 create directory dir as '/tmp'; --1. 使用数据库字符集将 XML 节点写入指定文件。 DECLARE FPATH VARCHAR2(1000); DOC DBE_XMLDOM.DOMDOCUMENT; BEGIN DOC := DBE_XMLDOM.NEWDOMDOCUMENT(' ACHILD TXT B TXT '); FPATH := 'dir/simplexml.xml'; DBE_XMLDOM.WRITETOFILE(DOC, FPATH); END; / -- 预期结果为： ANONYMOUS BLOCK EXECUTE --2. 使用指定字符集将 XML 文档写入指定文件。 DECLARE SRC VARCHAR(1000); FPATH VARCHAR2(1000); DOC DBE_XMLDOM.DOMDOCUMENT; ELE DBE_XMLDOM.DOMELEMENT; BEGIN FPATH := 'dir/simplexml.xml'; SRC := ' ACHILD TXT B TXT '; DOC := DBE_XMLDOM.NEWDOMDOCUMENT(SRC); ELE := DBE_XMLDOM.GETDOCUMENTELEMENT(DOC); DBE_XMLDOM.WRITETOFILE(DBE_XMLDOM.MAKENODE(ELE), FPATH, 'ASCII'); DBE_XMLDOM.FREEDOCUMENT(DOC); END; / -- 预期结果为： ANONYMOUS BLOCK EXECUTE -- 清理环境 drop directory dir;
```
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
```

DBE_XMLDOM.GETSESSIONTREENUM

查询当前session中所有类型的dom树数量。DBE_XMLDOM.GETSESSIONTREENUM的函数原型为：

DBE_XMLDOM.GETSESSIONTREENUM()
RETURN INTEGER;

对于使用过FREEELEMENT和FREENODE的dom树，该函数依然会将其统计在内。

示例：

| ``` -- 创建三个document，并获取当前session中所有dom树的数量 DECLARE doc DBE_XMLDOM.DOMDocument; doc2 DBE_XMLDOM.DOMDocument; doc3 DBE_XMLDOM.DOMDocument; buffer varchar2(1010); BEGIN -- 创建三个document doc := DBE_XMLDOM.NEWDOMDOCUMENT(' Im text Im text too Text '); doc2 := DBE_XMLDOM.NEWDOMDOCUMENT(' Ryzen 9 3950X 32GBx2 DDR4 3200MHz ROG X570i RTX2070 Super 1TB NVMe Toshiba + 2TB NVMe WD Black 12TB WD Digital CORSAIR SF750 LIANLI TU150 '); doc3 := DBE_XMLDOM.NEWDOMDOCUMENT(' The Autobiography of Benjamin Franklin Benjamin Franklin 8.99 The Confidence Man Herman Melville 11.99 The Gorgias Plato 9.99 '); -- 打印id DBE_OUTPUT.PRINT_LINE(doc.id); DBE_OUTPUT.PRINT_LINE(doc2.id); DBE_OUTPUT.PRINT_LINE(doc3.id); -- 调用该函数并打印 DBE_OUTPUT.PRINT_LINE(DBE_XMLDOM.GETSESSIONTREENUM()); -- 释放document DBE_XMLDOM.FREEDOCUMENT(doc); DBE_XMLDOM.FREEDOCUMENT(doc2); DBE_XMLDOM.FREEDOCUMENT(doc3); END; / -- 预期结果为（若当前session之前执行过xmldom接口，则结果是不确定的）： 00000000000000000200000001 01000000000000000300000001 02000000000000000400000001 3 ANONYMOUS BLOCK EXECUTE

| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |

DBE_XMLDOM.GETDOCTREESINFO

查询当前session中Document类型的dom树信息，如内存占用等。DBE_XMLDOM.GETDOCTREESINFO的函数原型为：

DBE_XMLDOM.GETDOCTREESINFO()
RETURN VARCHAR2;

该函数只统计Document类型的dom树节点。

示例：

| ``` -- 创建三个document，并获取当前session中document类型的树的信息 DECLARE doc DBE_XMLDOM.DOMDocument; doc2 DBE_XMLDOM.DOMDocument; doc3 DBE_XMLDOM.DOMDocument; buffer varchar2(1010); BEGIN -- 创建三个document doc := DBE_XMLDOM.NEWDOMDOCUMENT(' Im text Im text too Text '); doc2 := DBE_XMLDOM.NEWDOMDOCUMENT(' Ryzen 9 3950X 32GBx2 DDR4 3200MHz ROG X570i RTX2070 Super 1TB NVMe Toshiba + 2TB NVMe WD Black 12TB WD Digital CORSAIR SF750 LIANLI TU150 '); doc3 := DBE_XMLDOM.NEWDOMDOCUMENT(' The Autobiography of Benjamin Franklin Benjamin Franklin 8.99 The Confidence Man Herman Melville 11.99 The Gorgias Plato 9.99 '); -- 打印id DBE_OUTPUT.PRINT_LINE(doc.id); DBE_OUTPUT.PRINT_LINE(doc2.id); DBE_OUTPUT.PRINT_LINE(doc3.id); -- 调用该函数并打印 DBE_OUTPUT.PRINT_LINE(DBE_XMLDOM.GETDOCTREESINFO()); -- 释放document DBE_XMLDOM.FREEDOCUMENT(doc); DBE_XMLDOM.FREEDOCUMENT(doc2); DBE_XMLDOM.FREEDOCUMENT(doc3); END; / -- 预期结果为（若当前session之前执行过xmldom接口，则结果是不确定的）： 00000000000000000200000001 01000000000000000300000001 02000000000000000400000001 |ID:00000000000000000200000001 |Node count:11 |Memory used:151 byte | |ID:01000000000000000300000001 |Node count:22 |Memory used:322 byte | |ID:02000000000000000400000001 |Node count:48 |Memory used:654 byte | ANONYMOUS BLOCK EXECUTE

| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |

DBE_XMLDOM.GETDETAILDOCTREEINFO

查询传入的document内的各类型子节点的数量。DBE_XMLDOM.GETDETAILDOCTREEINFO的函数原型为：

DBE_XMLDOM.GETDETAILDOCTREEINFO(
    doc     IN      DOMDOCUMENT
)
RETURN VARCHAR2;

参数	描述
doc	指定的DOMDOCUMENT节点

该函数只统计Document类型的dom树节点。

示例：

| ``` -- 创建三个document，并使用该函数分别获取每一个document内的各类型节点数量 DECLARE doc DBE_XMLDOM.DOMDocument; doc2 DBE_XMLDOM.DOMDocument; doc3 DBE_XMLDOM.DOMDocument; buffer varchar2(1010); BEGIN -- 创建三个document doc := DBE_XMLDOM.NEWDOMDOCUMENT(' Im text Im text too Text '); doc2 := DBE_XMLDOM.NEWDOMDOCUMENT(' Ryzen 9 3950X 32GBx2 DDR4 3200MHz ROG X570i RTX2070 Super 1TB NVMe Toshiba + 2TB NVMe WD Black 12TB WD Digital CORSAIR SF750 LIANLI TU150 '); doc3 := DBE_XMLDOM.NEWDOMDOCUMENT(' The Autobiography of Benjamin Franklin Benjamin Franklin 8.99 The Confidence Man Herman Melville 11.99 The Gorgias Plato 9.99 '); -- 打印id DBE_OUTPUT.PRINT_LINE(doc.id); DBE_OUTPUT.PRINT_LINE(doc2.id); DBE_OUTPUT.PRINT_LINE(doc3.id); -- 调用该函数并打印 buffer := DBE_XMLDOM.GETDETAILDOCTREEINFO(doc); DBE_OUTPUT.PRINT_LINE(buffer); buffer := DBE_XMLDOM.GETDETAILDOCTREEINFO(doc2); DBE_OUTPUT.PRINT_LINE(buffer); buffer := DBE_XMLDOM.GETDETAILDOCTREEINFO(doc3); DBE_OUTPUT.PRINT_LINE(buffer); -- 释放document DBE_XMLDOM.FREEDOCUMENT(doc); DBE_XMLDOM.FREEDOCUMENT(doc2); DBE_XMLDOM.FREEDOCUMENT(doc3); END; / -- 预期结果为（若当前session之前执行过xmldom接口，则结果是不确定的）： 00000000000000000200000001 01000000000000000300000001 02000000000000000400000001 |ID:00000000000000000200000001 |Element count:5 |Attribute count:1 |Text count:4 | |ID:01000000000000000300000001 |Element count:9 |Attribute count:2 |Text count:10 | |ID:02000000000000000400000001 |Element count:18 |Attribute count:9 |Text count:20 | ANONYMOUS BLOCK EXECUTE

| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |

DBE_XMLDOM.GETELEMENTSBYTAGNAM

XML中按名称查找返回DOMNODELIST的节点。DBE_XMLDOM.GETELEMENTSBYTAGNAME的函数原型为：

DBE_XMLDOM.GETELEMENTSBYTAGNAME(
   doc        IN      DOMDOCUMENT,
   tagname    IN      VARCHAR2)
RETURN DOMNODELIST;

XML中按名称查找返回DOMNODELIST的节点。DBE_XMLDOM.GETELEMENTSBYTAGNAME的函数原型为：

DBE_XMLDOM.GETELEMENTSBYTAGNAME(
   elem       IN      DOMELEMENT,
   tagname       IN      VARCHAR2)
RETURN DOMNODELIST;

XML中按名称和命名空间查找返回DOMNODELIST的节点。DBE_XMLDOM.GETELEMENTSBYTAGNAME的函数原型为：

DBE_XMLDOM.GETELEMENTSBYTAGNAME(
   elem      IN     DOMELEMENT,
   tagname      IN     VARCHAR2,
   ns        IN     VARCHAR2)
 RETURN DOMNODELIST;

参数	描述
doc	指定的DOMDOCUMENT节点。
elem	指定的DOMELEMENT节点。
tagname	标签名称。使用通配符（*）将匹配任何标签。
ns	命名空间。使用通配符（*）将匹配任何命名空间。

示例：

| ``` --1. 在DOMDOCUMENT节点通过TAGNAME匹配查找，返回匹配的DOMNODELIST节点列表。 DECLARE doc DBE_XMLDOM.DOMDocument; root_elem DBE_XMLDOM.DOMElement; child_node DBE_XMLDOM.DOMNODE; node_list DBE_XMLDOM.DOMNODELIST; buffer VARCHAR2(1000); BEGIN doc := DBE_XMLDOM.NEWDOMDOCUMENT(' Ryzen 9 3950X Ryzen 9 5950X_1 32GBx2 DDR4 3200MHzRyzen Ryzen 9 5950X_2 ROG X570i RTX2070 Super 1TB NVMe Toshiba + 2TB NVMe WD Black 12TB WD Digital CORSAIR SF750 LIANLI TU150 '); root_elem := DBE_XMLDOM.GETDOCUMENTELEMENT(doc); node_list := DBE_XMLDOM.GETELEMENTSBYTAGNAME(doc, 'cpu'); child_node := DBE_XMLDOM.ITEM(node_list, 2); DBE_XMLDOM.WRITETOBUFFER(child_node, buffer); DBE_OUTPUT.PRINT_LINE(buffer); END; / -- 预期结果为： Ryzen Ryzen 9 5950X_2 ANONYMOUS BLOCK EXECUTE --2. 在DOMELEMENT节点通过TAGNAME匹配查找，返回匹配的DOMNODELIST节点列表。 DECLARE doc DBE_XMLDOM.DOMDocument; root_elem DBE_XMLDOM.DOMElement; child_node DBE_XMLDOM.DOMNODE; node_list DBE_XMLDOM.DOMNODELIST; buffer VARCHAR2(1000); BEGIN doc := DBE_XMLDOM.NEWDOMDOCUMENT(' Ryzen 9 3950X Ryzen 9 5950X_1 32GBx2 DDR4 3200MHzRyzen 9 5950X_2Ryzen 9 5950X_3Ryzen 9 5950X_4 ROG X570i RTX2070 Super 1TB NVMe Toshiba + 2TB NVMe WD Black 12TB WD Digital CORSAIR SF750 LIANLI TU150 '); root_elem := DBE_XMLDOM.GETDOCUMENTELEMENT(doc); node_list := DBE_XMLDOM.GETELEMENTSBYTAGNAME(root_elem, 'cpu'); child_node := DBE_XMLDOM.ITEM(node_list, 3); DBE_XMLDOM.WRITETOBUFFER(child_node, buffer); DBE_OUTPUT.PRINT_LINE(buffer); END; / -- 预期结果为： Ryzen 9 5950X_3Ryzen 9 5950X_4 ANONYMOUS BLOCK EXECUTE --3. 在DOMELEMENT节点通过TAGNAME以及NAMESPACE匹配查找，返回匹配的DOMNODELIST节点列表。 DECLARE doc DBE_XMLDOM.DOMDocument; root_elem DBE_XMLDOM.DOMElement; child_node DBE_XMLDOM.DOMNODE; node_list DBE_XMLDOM.DOMNODELIST; buffer VARCHAR2(1000); BEGIN doc := DBE_XMLDOM.NEWDOMDOCUMENT(' Ryzen 9 3950X Ryzen 9 5950X_1 <h:cpu>ns Ryzen 9 5950X_2</h:cpu> 32GBx2 DDR4 3200MHzRyzen 9 5950X_3Ryzen 9 5950X_4Ryzen 9 5950X_5 ROG X570i RTX2070 Super 1TB NVMe Toshiba + 2TB NVMe WD Black 12TB WD Digital CORSAIR SF750 LIANLI TU150 '); root_elem := DBE_XMLDOM.GETDOCUMENTELEMENT(doc); node_list := DBE_XMLDOM.GETELEMENTSBYTAGNAME(root_elem, 'cpu', 'www.huawei.com'); child_node := DBE_XMLDOM.ITEM(node_list, 0); DBE_XMLDOM.WRITETOBUFFER(child_node, buffer); DBE_OUTPUT.PRINT_LINE(buffer); END; / -- 预期结果为： <h:cpu>ns Ryzen 9 5950X_2</h:cpu> ANONYMOUS BLOCK EXECUTE

| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |

更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…

参数	描述
doc	指定的DOMDOCUMENT节点。
fileName	要写入的文件。
n	指定的DOMNODE节点。
charset	指定字符集。