GETXMLTYPE v18

Suggest edits

The GETXMLTYPE function converts a DOMDocument to XMLTYPE and returns it.

GETXMLTYPE(doc IN DOMDOCUMENT) RETURN XMLTYPE

Parameters

doc

The DOMDocument.

Examples

This example creates an XML DOMDocument, sets the version to 1.0, and converts it to an XMLType object:

DECLARE
   l_xmltype XMLTYPE;
   l_domdoc DBMS_XMLDOM.DOMDocument;


BEGIN
   l_domdoc := DBMS_XMLDOM.NEWDOMDOCUMENT();
   DBMS_XMLDOM.SETVERSION(l_domdoc, '1.0');
   l_xmltype := DBMS_XMLDOM.GETXMLTYPE(l_domdoc);
   DBMS_OUTPUT.PUT_LINE(l_xmltype.getStringVal());
END;

This example takes an XML string as input, converts it to a DOMDocument, and adds a new element to the document. It then converts the DOMDocument back to XMLType.

DECLARE
   doc DBMS_XMLDOM.domdocument;
   xmldata xmltype:=xmltype('<r><a>10</a><b><bb>20</bb></b></r>');
   l_xmltype XMLTYPE;
   elem DBMS_XMLDOM.DOMElement;
BEGIN
   doc := DBMS_XMLDOM.NEWDOMDOCUMENT(xmldata);
   elem := DBMS_XMLDOM.CREATEELEMENT(doc, 'testTag');
   PERFORM DBMS_XMLDOM.APPENDCHILD(DBMS_XMLDOM.MAKENODE(doc), DBMS_XMLDOM.MAKENODE(elem));
   l_xmltype := DBMS_XMLDOM.GETXMLTYPE(doc);
   DBMS_OUTPUT.PUT_LINE(l_xmltype::varchar2);
END;
← Prev

GETNODENAME

↑ Up

DBMS_XMLDOM

Next →

ITEM