The DBMS_XMLDOM package is used to access XMLType objects, and implements the Document Object Model (DOM), an application programming interface for HTML and XML documents.
This chapter contains the following topics:
Overview
Constants
Types
Exceptions
DOMNode Subprograms
DOMAttr Subprograms
DOMCDataSection Subprograms
DOMCharacterData Subprograms
DOMComment Subprograms
DOMDocument Subprograms
DOMDocumentFragment Subprograms
DOMDocumentType Subprograms
DOMElement Subprograms
DOMEntity Subprograms
DOMEntityReference Subprograms
DOMImplementation Subprograms
DOMNamedNodeMap Subprograms
DOMNodeList Subprograms
DOMNotation Subprograms
DOMProcessingInstruction Subprograms
DOMText Subprograms
The Document Object Model (DOM) is an application programming interface (API) for HTML and XML documents. It defines the logical structure of documents, and the manner in which they are accessed and manipulated. In the DOM specification, the term "document" is used in the broad sense. XML is being increasingly used to represent many different kinds of information that may be stored in diverse systems. This information has been traditionally be seen as "data"; nevertheless, XML presents this data as documents, and the DBMS_XMLDOM package allows you access to both schema-based and non schema-based documents.
Note:
Before database startup, the read-from and write-to directories in the initialization.ORA file must be specified; for example: UTL_FILE_DIR=/mypath/insidemypath.
Read-from and write-to files must be on the server file system.
With DOM, anything found in an HTML or XML document can be accessed, changed, deleted, or added using the Document Object Model, with a few exceptions. In particular, the DOM interfaces for the XML internal and external subsets have not yet been specified.
One important objective of the W3C DOM specification is to provide a standard programming interface that can be used in a wide variety of environments, programming languages, and applications. Because the DOM standard is object-oriented while PL/SQL is essentially a procedural language, some changes had to be made:
Various DOM interfaces such as Node, Element, and others have equivalent PL/SQL types DOMNode, DOMElement, respectively.
Various DOMException codes such as WRONG_DOCUMENT_ERR, HIERARCHY_REQUEST_ERR, and others, have similarly named PL/SQL exceptions.
Various DOM Node type codes such as ELEMENT_NODE, ATTRIBUTE_NODE, and others, have similarly named PL/SQL constants.
Subprograms defined on a DOM type become functions or procedures that accept it as a parameter. For example, to perform APPENDCHILD Function on a DOMNode n, the APPENDCHILD FunctionPL/SQL function is provided.
To perform setAttribute on a DOMElement elemSETATTRIBUTE Procedures, use PL/SQL procedure .
DOM defines an inheritance hierarchy. For example, Document, Element, and Attr are defined to be subtypes of Node (see Figure 125-1). Thus, a method defined in the Node interface should be available in these as well. Since such inheritance is not supported in PL/SQL, it is implemented through direct invocation of the MAKENODE function. Calling MAKENODE on various DOM types converts these types into a DOMNode. The appropriate functions or procedures that accept DOMNodes can then be called to operate on these types. If, subsequently, type specific functionality is desired, the DOMNode can be converted back into the original type by the makeXXX functions, where DOMXXX is the desired DOM type.
Figure 125-1 Inheritance Diagram for DOM Types

The implementation of this interface follows the REC-DOM-Level-1-19981001.
Defined constants of DBMS_XMLDOM are listed in Table 125-1.
Table 125-1 Defined Constants for DBMS_XMLDOM
| Constant | Type | Value | Description |
|---|---|---|---|
|
|
|
1 |
The Node is an Element. |
|
|
|
2 |
The Node is an Attribute. |
|
|
|
3 |
The Node is a Text node. |
|
|
|
4 |
The Node is a CDataSection. |
|
|
|
5 |
The Node is an Entity Reference. |
|
|
|
6 |
The Node is an Entity. |
|
|
|
7 |
The Node is a Processing Instruction. |
|
|
|
8 |
The Node is a Comment. |
|
|
|
9 |
The Node is a Document. |
|
|
|
10 |
The Node is a Document Type Definition. |
|
|
|
11 |
The Node is a Document fragment. |
|
|
|
12 |
The Node is a Notation. |
The following types for DBMS_XMLDOM.DOMTYPE are defined in Table 125-2:
| Type | Description |
|---|---|
|
|
Implements the DOM Attribute interface. |
|
|
Implements the DOM CDataSection interface. |
|
|
Implements the DOM Character Data interface. |
|
|
Implements the DOM Comment interface. |
|
|
Implements the DOM Document interface. |
|
|
Implements the DOM DocumentFragment interface. |
|
|
Implements the DOM Document Type interface. |
|
|
Implements the DOM Element interface. |
|
|
Implements the DOM Entity interface. |
|
|
Implements the DOM EntityReference interface. |
|
|
Implements the DOM Implementation interface. |
|
|
Implements the DOM Named Node Map interface. |
|
|
Implements the DOM Node interface. |
|
|
Implements the DOM NodeList interface. |
|
|
Implements the DOM Notation interface. |
|
|
Implements the DOM Processing instruction interface. |
|
|
Implements the DOM Text interface. |
The exceptions listed in Table 125-3 are defined for DBMS_XMLDOM:
Table 125-3 Exceptions for DBMS_XMLDOM
| Exception | Description |
|---|---|
|
|
If the specified range of text does not fit into a |
|
|
If any node is inserted somewhere it doesn't belong. |
|
|
If index or size is negative, or greater than the allowed value. |
|
|
If an attempt is made to add an attribute that is already in use elsewhere. |
|
|
If an invalid or illegal character is specified, such as in a name. See production 2 in the XML specification for the definition of a legal character, and production 5 for the definition of a legal name character. |
|
|
If data is specified for a node that does not support data. |
|
|
If an attempt is made to reference a node in a context where it does not exist. |
|
|
If an attempt is made to modify an object where modifications are not allowed. |
|
|
If the implementation does not support the requested type of object or operation. |
|
|
If a node is used in a different document than the one that created it (that doesn't support it). |
DBMS_XMLDOM subprograms are divided into groups according to W3C Interfaces.
Table 125-4 Summary of DOMNode Subprograms; DBMS_XMLDOM
| Subprogram | Description |
|---|---|
|
Adopts a node from another document. |
|
|
Appends a new child to the node. |
|
|
Clones the node. |
|
|
Frees all resources associated with the node. |
|
|
Retrieves the attributes of the node. |
|
|
Retrieves the children of the node. |
|
|
Retrieves the expanded name of the node. |
|
|
Retrieves the first child of the node. |
|
|
Retrieves the last child of the node. |
|
|
Retrieves the local part of the qualified name. |
|
|
Retrieves the node's namespace URI. |
|
|
Retrieves the next sibling of the node. |
|
|
Retrieves the Name of the Node. |
|
|
Retrieves the Type of the node. |
|
|
Retrieves the Value of the Node. |
|
|
Retrieves the owner document of the node. |
|
|
Retrieves the parent of this node. |
|
|
Retrieves the namespace prefix. |
|
|
Retrieves the previous sibling of the node. |
|
|
Retrieves the associated schema URI. |
|
|
Tests if the node has attributes. |
|
|
Tests if the node has child nodes. |
|
|
Imports a node from another document. |
|
|
Inserts a child before the reference child. |
|
|
Tests if the node is |
|
|
Casts the node to an Attribute. |
|
|
Casts the node to a CData Section. |
|
|
Casts the node to Character Data. |
|
|
Casts the node to a Comment. |
|
|
Casts the node to a DOM Document. |
|
|
Casts the node to a DOM Document Fragment. |
|
|
Casts the node to a DOM Document Type. |
|
|
Casts the node to a DOM Element. |
|
|
Casts the node to a DOM Entity. |
|
|
Casts the node to a DOM Entity Reference. |
|
|
Casts the node to a DOM Notation. |
|
|
Casts the node to a DOM Processing Instruction. |
|
|
Casts the node to a DOM Text. |
|
|
Removes a specified child from a node. |
|
|
Replaces the old child with a new child. |
|
|
Sets the Value of the node. |
|
|
Sets the namespace prefix. |
|
|
Writes the contents of the node to a buffer. |
|
|
Writes the contents of the node to a |
|
|
Writes the contents of the node to a file. |
Table 125-5 Summary of DOMAttr Subprograms; DBMS_XMLDOM
| Method | Description |
|---|---|
|
Retrieves the expanded name of the attribute. |
|
|
Retrieves the local name of the attribute. |
|
|
Retrieves the name of the attribute. |
|
|
Retrieves the NS URI of the attribute. |
|
|
Retrieves the Element node, parent of the attribute. |
|
|
Retrieves the Qualified Name of the attribute. |
|
|
Tests if attribute was specified in the element. |
|
|
Retrieves the value of the attribute. |
|
|
Tests if the Attribute node is |
|
|
Casts the Attribute to a node. |
|
|
Sets the value of the attribute. |
Table 125-6 Summary of DOMCdata Subprograms; DBMS_XMLDOM
| Method | Description |
|---|---|
|
Tests if the |
|
|
Casts the |
Table 125-7 Summary of DOMCharacterData Subprograms; DBMS_XMLDOM
| Method | Description |
|---|---|
|
Appends the given data to the node data. |
|
|
Deletes the data from the given offSets. |
|
|
Retrieves the data of the node. |
|
|
Retrieves the length of the data. |
|
|
Inserts the data in the node at the given offSets. |
|
|
Tests if the CharacterData is |
|
|
Casts the CharacterData to a node. |
|
|
Changes a range of characters in the node. |
|
|
Sets the data to the node. |
|
|
Retrieves the substring of the data. |
Table 125-8 Summary of DOMComment Subprograms; DBMS_XMLDOM
| Method | Description |
|---|---|
|
Tests if the comment is |
|
|
Casts the Comment to a node. |
Table 125-9 Summary of DOMDocument Subprograms; DBMS_XMLDOM
| Method | Description |
|---|---|
|
Creates an Attribute. |
|
|
Creates a |
|
|
Creates a Comment node. |
|
|
Creates a new Document. |
|
|
Creates a new Document Fragment. |
|
|
Creates a new Element. |
|
|
Creates an Entity reference. |
|
|
Creates a Processing Instruction. |
|
|
Creates a Text node. |
|
|
Frees the document fragment. |
|
|
Frees the document. |
|
|
Retrieves the DTD of the document. |
|
|
Retrieves the root element of the document. |
|
|
Retrieves the elements in the by tag name. |
|
|
Retrieves the DOM implementation. |
|
|
Retrieves the standalone property of the document. |
|
|
Retrieves the version of the document. |
|
|
Retrieves the |
|
|
Tests if the document is |
|
|
Casts the document to a node. |
|
|
Creates a new document. |
|
|
Sets the DTD of the document. |
|
|
Sets the standalone property of the document. |
|
|
Sets the version of the document. |
|
|
Writes the document to a buffer. |
|
|
Writes the document to a |
|
|
Writes the document to a file. |
Table 125-10 Summary of DOMDocumentFragment Subprograms; DBMS_XMLDOM
| Method | Description |
|---|---|
|
Frees the specified document fragment. |
|
|
Tests if the DocumentFragment is |
|
|
Casts the Document Fragment to a node. |
|
|
Writes the contents of a document fragment into a buffer. |
Table 125-11 Summary of DOMDocumentType Subprograms; DBMS_XMLDOM
| Method | Description |
|---|---|
|
Finds the specified entity in the document type. |
|
|
Finds the specified notation in the document type. |
|
|
Retrieves the nodemap of entities in the Document type. |
|
|
Retrieves the name of the Document type. |
|
|
Retrieves the nodemap of the notations in the Document type. |
|
|
Retrieves the public ID of the document type. |
|
|
Retrieves the system ID of the document type. |
|
|
Tests if the Document Type is |
|
|
Casts the document type to a node. |
Table 125-12 Summary of DOMElement Subprograms; DBMS_XMLDOM
| Method | Description |
|---|---|
|
Retrieves the attribute node by name. |
|
|
Retrieves the attribute node by name. |
|
|
Retrieves children of the element by tag name. |
|
|
Retrieves elements in the subtree by tagname. |
|
|
Retrieves the expanded name of the element. |
|
|
Retrieves the local name of the element. |
|
|
Retrieves the NS URI of the element. |
|
|
Retrieves the qualified name of the element. |
|
|
Retrieves the Tag name of the element. |
|
|
Tests if an attribute exists |
|
|
Tests if the Element is |
|
|
Casts the Element to a node. |
|
|
Normalizes the text children of the element. |
|
|
Removes the attribute specified by the name. |
|
|
Removes the attribute node in the element. |
|
|
Resolve the prefix to a namespace URI. |
|
|
Sets the attribute specified by the name. |
|
|
Sets the attribute node in the element. |
Table 125-13 Summary of DOMEntity Subprograms; DBMS_XMLDOM
| Method | Description |
|---|---|
|
Retrieves the notation name of the entity. |
|
|
Retrieves the public Id of the entity. |
|
|
Retrieves the system Id of the entity. |
|
|
Tests if the Entity is |
|
|
Casts the Entity to a node. |
Table 125-14 Summary of DOMEntityReference Subprograms; DBMS_XMLDOM
| Method | Description |
|---|---|
|
Tests if the |
|
|
Casts the |
Table 125-15 Summary of DOMImplementation Subprograms; DBMS_XMLDOM
| Method | Description |
|---|---|
|
Tests if the |
|
|
Tests if the |
Table 125-16 Summary of DOMNamedNodeMap Subprograms; DBMS_XMLDOM
| Method | Description |
|---|---|
|
Retrieves the number of items in the map. |
|
|
Retrieves the item specified by the name. |
|
|
Tests if the |
|
|
Retrieves the item given the index in the map. |
|
|
Removes the item specified by name. |
|
|
Sets the item in the map specified by the name. |
Table 125-17 Summary of DOMNodeList Subprograms; DBMS_XMLDOM
| Method | Description |
|---|---|
|
Retrieves the number of items in the list. |
|
|
Tests if the |
|
|
Retrieves the item given the index in the |
Table 125-18 Summary of DOMNotation Subprograms; DBMS_XMLDOM
| Method | Description |
|---|---|
|
Retrieves the public Id of the notation. |
|
|
Retrieves the system Id of the notation. |
|
|
Tests if the Notation is |
|
|
Casts the notation to a node. |
Table 125-19 Summary of DOMProcessingInstruction Subprograms; DBMS_XMLDOM
| Method | Description |
|---|---|
|
Retrieves the data of the processing instruction. |
|
|
Retrieves the target of the processing instruction. |
|
|
Tests if the Processing Instruction is |
|
|
Casts the Processing Instruction to a node. |
|
|
Sets the data of the processing instruction. |
Table 125-21 Summary of DBMS_XMLDOM Package Subprogram
| Subprogram | Description | Group |
|---|---|---|
|
Adopts a node from another document |
||
|
Appends a new child to the node |
||
|
Appends the given data to the node data |
||
|
Clones the node |
||
|
Creates an Attribute |
||
|
Creates a |
||
|
Creates a Comment node |
||
|
Creates a new Document |
||
|
Creates a new Document Fragment |
||
|
Creates a new Element |
||
|
Creates an Entity reference |
||
|
Creates a Processing Instruction |
||
|
Creates a Text node |
||
|
Deletes the data from the given offSets |
||
|
Finds the specified entity in the document type |
||
|
Finds the specified notation in the document type |
||
|
Frees the document fragment |
||
|
Frees the document |
||
|
Frees all resources associated with the node |
||
|
Retrieves the attribute node by name |
||
|
Retrieves the attribute node by name |
||
|
Retrieves the attributes of the node |
||
|
Retrieves the children of the node |
||
|
Retrieves children of the element by tag name |
||
|
Retrieves
|
||
|
Retrieves the DTD of the document |
||
|
Retrieves the root element of the document |
||
|
Retrieves
|
||
|
Retrieves the nodemap of entities in the Document type |
||
|
Retrieves
|
||
|
Retrieves the first child of the node |
||
|
Retrieves the DOM implementation |
||
|
Retrieves the last child of the node |
||
|
Retrieves
|
||
|
Retrieves
|
||
|
Retrieves
|
||
|
Retrieves
|
||
|
Retrieves
|
||
|
Retrieves the next sibling of the node |
||
|
Retrieves the Name of the Node |
||
|
Retrieves the Type of the node |
||
|
Retrieves the Value of the Node |
||
|
Retrieves the notation name of the entity |
||
|
Retrieves the nodemap of the notations in the Document type |
||
|
Retrieves the target of the processing instruction |
||
|
Retrieves the owner document of the node |
||
|
Retrieves the Element node, parent of the attribute |
||
|
Retrieves the parent of this node |
||
|
Retrieves the namespace prefix ) |
||
|
Retrieves the previous sibling of the node |
||
|
Retrieves
|
||
|
Retrieves
|
||
|
Retrieves the associated schema URI |
||
|
Tests if attribute was specified in the element. |
||
|
Retrieves the standalone property of the document |
||
|
Retrieves
|
||
|
Retrieves the Tag name of the element |
||
|
Retrieves the value of the attribute |
||
|
Retrieves the version of the document |
||
|
Retrieves the |
||
|
Tests if the node has attributes |
||
|
Tests if an attribute exists |
||
|
Tests if the node has child nodes |
||
|
Tests if the |
||
|
Imports a node from another document |
||
|
Inserts a child before the reference child |
||
|
Inserts the data in the node at the given offSets |
||
|
Tests
|
|
|
|
Retrieves
|
||
|
Casts the node to an Attribute |
||
|
Casts the node to a CData Section |
||
|
Casts the node to Character Data |
||
|
Casts the node to a Comment |
||
|
Casts the node to a DOM Document |
||
|
Casts the node to a DOM Document Fragment |
||
|
Casts the node to a DOM Document Type |
||
|
Casts the node to a DOM ElemenT |
||
|
Casts the node to a DOM Entity |
||
|
Casts the node to a DOM Entity Reference |
||
|
Casts
|
|
|
|
Casts the node to a DOM Notation |
||
|
Casts the node to a DOM Processing Instruction |
||
|
Casts the node to a DOM Text |
||
|
Creates a new document |
||
|
Normalizes the text children of the element |
||
|
Removes the attribute specified by the name |
||
|
Removes the attribute node in the element |
||
|
Removes a specified child from a node |
||
|
Removes the item specified by name |
||
|
Replaces the old child with a new child |
||
|
Changes a range of characters in the node |
||
|
Resolve the prefix to a namespace URI |
||
|
Sets the attribute specified by the name |
||
|
Sets the attribute node in the element |
||
|
Sets
|
||
|
Sets the DTD of the document. |
||
|
Sets the item in the map specified by the name |
||
|
Sets the Value of the node |
||
|
Sets the namespace prefix |
||
|
Sets the standalone property of the document |
||
|
Sets the value of the attribute |
||
|
Sets the version of the document |
||
|
Splits the contents of the text node into 2 text nodes |
||
|
Retrieves the substring of the data |
||
|
Writes
|
||
|
Writes
|
||
|
Writes
|
This function adopts a node from another document, and returns this new node.
See Also:
DOMNode Subprograms for other subprograms in this groupDBMS_XMLDOM.ADOPTNODE( doc IN DOMDocument, importedNode IN DOMNode) RETURN DOMNODE;
Table 125-22 ADOPTNODE Function Parameters
| Parameter | Description |
|---|---|
|
|
Document that is adopting the node |
|
|
Node to adopt |
This function adds the node newchild to the end of the list of children of this node, and returns the newly added node. If the newchild is already in the tree, it is first removed.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.APPENDCHILD( n IN DOMNode, newchild IN DOMNode) RETURN DOMNODE;
Table 125-23 APPENDCHILD Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
The child to be appended to the list of children of node |
This procedure appends the string to the end of the character data of the node. Upon success, data provides access to the concatenation of data and the specified string argument.
See Also:
DOMCharacterData SubprogramsDBMS_XMLDOM.APPENDDATA( cd IN DOMCHARACTERDATA, arg IN VARCHAR2);
Table 125-24 APPENDDATA Procedure Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
The data to append to the existing data |
This function returns a duplicate of this node, and serves as a generic copy constructor for nodes. The duplicate node has no parent, its parent node is NULL.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.CLONENODE( n IN DOMNODE, deep IN BOOLEAN) RETURN DOMNODE;
Table 125-25 CLONENODE Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
Determines if children are to be cloned |
Cloning an Element copies all attributes and their values, including those generated by the XML processor to represent defaulted attributes, but this method does not copy any text it contains unless it is a deep clone, since the text is contained in a child Text node.
Cloning an Attribute directly, as opposed to be cloned as part of an Element cloning operation, returns a specified attribute (specified is TRUE).
Cloning any other type of node simply returns a copy of this node.
This function creates a DOMATTR node.
See Also:
DOMDocument SubprogramsCreates a DOMATTR with the specified name:
DBMS_XMLDOM.CREATEATTRIBUTE( doc IN DOMDOCUMENT, name IN VARCHAR2) RETURN DOMATTR;
Creates a DOMATTR with the specified name and namespace URI:
DBMS_XMLDOM.CREATEATTRIBUTE( doc IN DOMDOCUMENT, qname IN VARCHAR2, ns IN VARCHAR2) RETURN DOMATTR;
Table 125-26 CREATEATTRIBUTE Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
New attribute qualified name |
|
|
Namespace |
This function creates a DOMCDATASECTION node.
See Also:
DOMDocument SubprogramsDBMS_XMLDOM.CREATECDATASECTION( doc IN DOMDOCUMENT, data IN VARCHAR2) RETURN DOMCDATASECTION;
Table 125-27 CREATECDATASECTION Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
Content of the |
This function creates a DOMCOMMENT node.
See Also:
DOMDocument SubprogramsDBMS_XMLDOM.CREATECOMMENT( doc IN DOMDOCUMENT, data IN VARCHAR2) RETURN DOMCOMMENT;
Table 125-28 CREATECOMMENT Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
Content of the |
This function creates a DOMDOCUMENT with specified namespace URI, root element name, DTD.
See Also:
DOMDocument SubprogramsDBMS_XMLDOM.CREATEDOCUMENT( namespaceURI IN VARCHAR2, qualifiedName IN VARCHAR2, doctype IN DOMTYPE := NULL) RETURN DOMDOCUMENT;
Table 125-29 CREATEDOCUMENT Function Parameters
| Parameter | Description |
|---|---|
|
|
Namespace URI |
|
|
Root element name |
|
|
Document type |
This function creates a DOMDOCUMENTFRAGMENT.
See Also:
DOMDocument SubprogramsDBMS_XMLDOM.CREATEDOCUMENTFRAGMENT( doc IN DOMDOCUMENT) RETURN DOMDOCUMENTFRAGMENT;
This function creates a DOMELEMENT.
See Also:
DOMDocument SubprogramsCreates a DOMElement with specified name:
DBMS_XMLDOM.CREATEELEMENT( doc IN DOMDOCUMENT, tagName IN VARCHAR2) RETURN DOMELEMENT;
Creates a DOMElement with specified name and namespace URI:
DBMS_XMLDOM.CREATEELEMENT( doc IN DOMDOCUMENT, tagName IN VARCHAR2, ns IN VARCHAR2) RETURN DOMELEMENT;
Table 125-31 CREATEELEMENT Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
Tagname for new |
|
|
Namespace |
This function creates a DOMENTITYREFERENCE node.
See Also:
DOMDocument SubprogramsDBMS_XMLDOM.CREATEENTITYREFERENCE( doc IN DOMDOCUMENT, name IN VARCHAR2) RETURN DOMENTITYREFERENCE;
Table 125-32 CREATEENTITYREFERENCE Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
New entity reference name |
This function creates a DOMPROCESSINGINSTRUCTION node.
See Also:
DOMDocument SubprogramsDBMS_XMLDOM.CREATEPROCESSINGINSTRUCTION( doc IN DOMDocument, target IN VARCHAR2, data IN VARCHAR2) RETURN DOMPROCESSINGINSTRUCTION;
Table 125-33 CREATEPROCESSINGINSTRUCTION Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
Target of the new processing instruction |
|
|
Content data of the new processing instruction |
This function creates a DOMTEXT node.
See Also:
DOMDocument SubprogramsDBMS_XMLDOM.CREATETEXTNODE( doc IN DOMDocument, data IN VARCHAR2) RETURN DOMTEXT;
Table 125-34 CREATETEXTNODE Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
Content of the |
This procedure removes a range of characters from the node. Upon success, data and length reflect the change.
See Also:
DOMCharacterData SubprogramsDBMS_XMLDOM.DELETEDATA( cd IN DOMCHARACTERDATA, offset IN NUMBER, cnt IN NUMBER);
Table 125-35 DELETEDATA PROCEDURE Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
The offset from which to delete the data |
|
|
The number of characters (starting from offset) to delete |
This function finds an entity in the given DTD, and returns that entity if found.
See Also:
DOMDocumentType SubprogramsDBMS_XMLDOM.FINDENTITY( dt IN DOMDOCUMENTTYPE, name IN VARCHAR2, par IN BOOLEAN) RETURN DOMENTITY;
Table 125-36 FINDENTITY Function Parameters
| Parameter | Description |
|---|---|
|
|
The DTD |
|
|
Entity to find |
|
|
Flag to indicate type of entity; |
This function finds the notation in the given DTD, and returns it, if found.
See Also:
DOMDocumentType SubprogramsDBMS_XMLDOM.FINDNOTATION( dt IN DOMDocumentType, name IN VARCHAR2) RETURN DOMNOTATION;
Table 125-37 FINDNOTATION Function Parameters
| Parameter | Description |
|---|---|
|
|
The DTD |
|
|
The notation to find |
This procedure frees the specified document fragment.
DBMS_XMLDOM.FREEDOCFRAG( df IN DOMDOCUMENTFRAGMENT);
This procedure frees DOMDOCUMENT object.
See Also:
DOMDocument SubprogramsDBMS_XMLDOM.FREEDOCUMENT( doc IN DOMDOCUMENT);
This procedure frees all resources associated with a DOMNODE.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.FREENODE( n IN DOMNODE);
This function returns the value of a DOMELEMENT's attribute by name.
See Also:
DOMElement SubprogramsReturns the value of a DOMELEMENT's attribute by name:
DBMS_XMLDOM.GETATTRIBUTE( elem IN DOMELEMENT, name IN VARCHAR2) RETURN VARCHAR2;
Returns the value of a DOMELEMENT's attribute by name and namespace URI:
DBMS_XMLDOM.GETATTRIBUTE( elem IN DOMELEMENT, name IN VARCHAR2, ns IN VARCHAR2) RETURN VARCHAR2;
Table 125-41 GETATTRIBUTE Function Parameters
| Parameter | Description |
|---|---|
|
|
The |
|
|
Attribute name |
|
|
Namespace |
This function returns an attribute node from the DOMELEMENT by name. The function is overloaded. The specific forms of functionality are described along with the syntax declarations.
See Also:
DOMElement SubprogramsReturns an attribute node from the DOMELEMENT by name:
DBMS_XMLDOM.GETATTRIBUTENODE( elem IN DOMElement, name IN VARCHAR2) RETURN DOMATTR;
Returns an attribute node from the DOMELEMENT by name and namespace URI:
DBMS_XMLDOM.GETATTRIBUTENODE( elem IN DOMElement, name IN VARCHAR2, ns IN VARCHAR2) RETURN DOMATTR;
Table 125-42 GETATTRIBUTENODE Function Parameters
| Parameter | Description |
|---|---|
|
|
The |
|
|
Attribute name; * matches any attribute |
|
|
Namespace |
This function retrieves a NAMEDNODEMAP containing the attributes of this node (if it is an Element) or NULL otherwise.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.GETATTRIBUTES( n IN DOMNode) RETURN DOMNAMEDNODEMAP;
This function retrieves a DOMNODELIST that contains all children of this node. If there are no children, this is a DOMNODELIST containing no nodes.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.GETCHILDNODES( n IN DOMNode) RETURN DOMNodeList;
This function returns the children of the DOMELEMENT.
See Also:
DOMElement SubprogramsReturns children of the DOMELEMENT given the tag name:
DBMS_XMLDOM.GETCHILDRENBYTAGNAME( elem IN DOMElement, name IN VARCHAR2) RETURN DOMNODELIST;
Returns children of the DOMELEMENT given the tag name and namespace:
DBMS_XMLDOM.GETCHILDRENBYTAGNAME( elem IN DOMElement, name IN VARCHAR2, ns IN VARCHAR2) RETURN DOMNODELIST;
Table 125-45 GETCHILDRENBYTAGNAME Function Parameters
| Parameter | Description |
|---|---|
|
|
The |
|
|
Tag name |
|
|
Namespace |
This function is overloaded. The specific forms of functionality are described along with the syntax declarations.
Gets the character data of the node that implements this interface (See Also: DOMCharacterData Subprograms):
DBMS_XMLDOM.GETDATA( cd IN DOMCHARACTERDATA) RETURN VARCHAR2;
Returns the content data of the DOMProcessingInstruction (See Also: DOMProcessingInstruction Subprograms):
DBMS_XMLDOM.GETDATA( pi IN DOMPROCESSINGINSTRUCTION) RETURN VARCHAR2;
Table 125-46 GETDATA Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
The |
This function returns the DTD associated to the DOMDOCUMENT.
See Also:
DOMDocument SubprogramsDBMS_XMLDOM.GETDOCTYPE( doc IN DOMDOCUMENT) RETURN DOMDOCUMENTTYPE;
This function returns the root element of the DOMDOCUMENT.
See Also:
DOMDocument SubprogramsDBMS_XMLDOM.GETDOCUMENTELEMENT( doc IN DOMDOCUMENT) RETURN DOMELEMENT;
This function is overloaded. The specific forms of functionality are described along with the syntax declarations.
Returns a DOMNODELIST of all the elements with a given tagname (See Also: DOMDocument Subprograms):
DBMS_XMLDOM.GETELEMENTSBYTAGNAME( doc IN DOMDOCUMENT, tagname IN VARCHAR2) RETURN DOMNODELIST;
Returns the element children of the DOMELEMENT given the tag name (See Also: DOMElement Subprograms):
DBMS_XMLDOM.GETELEMENTSBYTAGNAME( elem IN DOMELEMENT, name IN VARCHAR2) RETURN DOMNODELIST;
Returns the element children of the DOMELEMENT given the tag name and namespace (See Also: DOMElement Subprograms):
DBMS_XMLDOM.GETELEMENTSBYTAGNAME( elem IN DOMELEMENT, name IN VARCHAR2, ns IN VARCHAR2) RETURN DOMNODELIST;
Table 125-49 GETELEMENTSBYTAGNAME Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
Name of the tag to match on |
|
|
The |
|
|
Tag name; using a wildcard(*) would match any tag |
|
|
Namespace |
This function retrieves a DOMNAMEDNODEMAP containing the general entities, both external and internal, declared in the DTD.
See Also:
DOMDocumentType SubprogramsDBMS_XMLDOM.GETENTITIES( dt IN DOMDocumentType) RETURN DOMNAMEDNODEMAP;
This subprogram is overloaded as a procedure and two functions. The specific forms of functionality are described along with the syntax declarations.
Retrieves the expanded name of the Node if is in an Element or Attribute type; otherwise, returns NULL (See Also: DOMNode Subprograms)
DBMS_XMLDOM.GETEXPANDEDNAME( n IN DOMNODE data OUT VARCHAR);
Returns the expanded name of the DOMAttr (See Also: DOMAttr Subprograms):
DBMS_XMLDOM.GETEXPANDEDNAME( a IN DOMAttr) RETURN VARCHAR2;
Returns the expanded name of the DOMElement (See Also: DOMElement Subprograms):
DBMS_XMLDOM.GETEXPANDEDNAME( elem IN DOMELEMENT) RETURN VARCHAR2;
Table 125-51 GETEXPANDEDNAME Procedure and Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
Returned expanded name of the |
|
|
|
|
|
|
This function retrieves the first child of this node. If there is no such node, this returns NULL.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.GETFIRSTCHILD( n IN DOMNODE) RETURN DOMNODE;
This function returns the DOMIMPLEMENTATION object that handles this DOMDOCUMENT.
See Also:
DOMDocument SubprogramsDBMS_XMLDOM.GETIMPLEMENTATION( doc IN DOMDOCUMENT) RETURN DOMIMPLEMENTATION;
This function retrieves the last child of this node. If there is no such node, this returns NULL.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.GETLASTCHILD( n IN DOMNODE) RETURN DOMNODE;
This function is overloaded. The specific forms of functionality are described along with the syntax declarations.
Gets the number of characters in the data. This may have the value zero, because CharacterData nodes may be empty (See Also: DOMCharacterData Subprograms):
DBMS_XMLDOM.GETLENGTH( cd IN DOMCHARACTERDATA) RETURN NUMBER;
Gets the number of nodes in this map. The range of valid child node indexes is 0 to length-1, inclusive (See Also: DOMNamedNodeMap Subprograms):
DBMS_XMLDOM.GETLENGTH( nnm IN DOMNAMEDNODEMAP) RETURN NUMBER;
Gets the number of nodes in the list. The range of valid child node indexes is 0 to length-1, inclusive (See Also: DOMNodeList Subprograms):
DBMS_XMLDOM.GETLENGTH( nl IN DOMNODELIST) RETURN NUMBER;
Table 125-55 GETLENGTH Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
|
|
|
|
This function is overloaded as a procedure and two functions. The specific forms of functionality are described alongside the syntax declarations.
Retrieves the local part of the node's qualified name (See Also: DOMNode Subprograms):
DBMS_XMLDOM.GETLOCALNAME( n IN DOMNODE, data OUT VARCHAR2);
Returns the local name of the DOMAttr (See Also: DOMAttr Subprograms):
DBMS_XMLDOM.GETLOCALNAME( a IN DOMATTR) RETURN VARCHAR2;
Returns the local name of the DOMElement (See Also: DOMElement Subprograms)
DBMS_XMLDOM.GETLOCALNAME( elem IN DOMELEMENT) RETURN VARCHAR2;
Table 125-56 GETLOCALNAME Procedure and Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
Returned local name. |
|
|
|
|
|
|
This function is overloaded. The specific forms of functionality are described alongside the syntax declarations.
Returns the name of this attribute (See Also: DOMAttr Subprograms):
DBMS_XMLDOM.GETNAME( a IN DOMATTR) RETURN VARCHAR2;
Retrieves the name of DTD, or the name immediately following the DOCTYPE keyword (See Also: DOMDocumentType Subprograms):
DBMS_XMLDOM.GETNAME( dt IN DOMDOCUMENTTYPE) RETURN VARCHAR2;
This function retrieves a node specified by name.
See Also:
DOMNamedNodeMap SubprogramsRetrieves a node specified by name:
DBMS_XMLDOM.GETNAMEDITEM( nnm IN DOMNAMEDNODEMAP, name IN VARCHAR2) RETURN DOMNODE;
Retrieves a node specified by name and namespace URI:
DBMS_XMLDOM.GETNAMEDITEM( nnm IN DOMNAMEDNODEMAP, name IN VARCHAR2, ns IN VARCHAR2) RETURN DOMNODE;
Table 125-58 GETNAMEDITEM Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
Name of the item to be retrieved |
|
|
Namespace |
This subprogram is overloaded as a procedure and two functions. The specific forms of functionality are described alongside the syntax declarations.
Retrieves the namespace URI associated with the node (See Also: DOMNode Subprograms):
DBMS_XMLDOM.GETNAMESPACE( n IN DOMNODE, data OUT VARCHAR2);
Retrieves the namespace of the DOMATTR (See Also: DOMAttr Subprograms):
DBMS_XMLDOM.GETNAMESPACE( a IN DOMATTR) RETURN VARCHAR2;
Retrieves the namespace of the DOMELEMENT (See Also: DOMElement Subprograms):
DBMS_XMLDOM.GETNAMESPACE( elem IN DOMELEMENT) RETURN VARCHAR2;
Table 125-59 GETNAMESPACE Procedure and Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
Returned namespace URI |
|
|
|
|
|
|
This function retrieves the node immediately following this node. If there is no such node, this returns NULL.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.GETNEXTSIBLING( n IN DOMNODE) RETURN DOMNode;
This function gets the name of the node depending on its type.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.GETNODENAME( n IN DOMNODE) RETURN VARCHAR2;
This function retrieves a code representing the type of the underlying object.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.GETNODETYPE( n IN DOMNODE) RETURN NUMBER;
This function gets the value of this node, depending on its type.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.GETNODEVALUE( n IN DOMNODE) RETURN VARCHAR2;
This function returns the notation name of the DOMENTITY.
See Also:
DOMEntity SubprogramsDBMS_XMLDOM.GETNOTATIONNAME( ent IN DOMENTITY) RETURN VARCHAR2;
This function retrieves a DOMNAMEDNODEMAP containing the notations declared in the DTD.
See Also:
DOMDocumentType SubprogramsDBMS_XMLDOM.GETNOTATIONS( dt IN DOMDOCUMENTTYPE) RETURN DOMNAMEDNODEMAP;
This function returns the target of the DOMPROCESSINGINSTRUCTION.
See Also:
DOMProcessingInstruction SubprogramsDBMS_XMLDOM.GETTARGET( pi IN DOMPROCESSINGINSTRUCTION) RETURN VARCHAR2;
This function retrieves the Document object associated with this node. This is also the Document object used to create new nodes. When this node is a Document or a Document Type that is not used with any Document yet, this is NULL.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.GETOWNERDOCUMENT( n IN DOMNODE) RETURN DOMDOCUMENT;
This function retrieves the Element node to which the specified Attribute is attached.
See Also:
DOMAttr SubprogramsDBMS_XMLDOM.GETOWNERELEMENT( a IN DOMATTR) RETURN DOMElement;
This function retrieves the parent of this node. All nodes, except Attr, Document, DocumentFragment, Entity, and Notation may have a parent. However, if a node has just been created and not yet added to the tree, or if it has been removed from the tree, this is NULL.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.GETPARENTNODE( n IN DOMNODE) RETURN DOMNODE;
This function retrieves the namespace prefix of the node.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.GETPREFIX( n IN DOMNODE) RETURN VARCHAR2;
This function retrieves the node immediately preceding this node. If there is no such node, this returns NULL.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.GETPREVIOUSSIBLING( n IN DOMNODE) RETURN DOMNODE;
This function is overloaded. The specific forms of functionality are described along with the syntax declarations.
Returns the public identifier of the given DTD (See Also: DOMDocumentType Subprograms):
DBMS_XMLDOM.GETPUBLICID( dt IN DOMDOCUMENTTYPE) RETURN VARCHAR2;
Returns the public identifier of the DOMENTITY (See Also: DOMEntity Subprograms):
DBMS_XMLDOM.GETPUBLICID( ent IN DOMENTITY) RETURN VARCHAR2;
Returns the public identifier of the DOMNOTATION (See Also: DOMNotation Subprograms):
DBMS_XMLDOM.GETPUBLICID( n IN DOMNOTATION) RETURN VARCHAR2;
Table 125-72 GETPUBLICID Function Parameters
| Parameter | Description |
|---|---|
|
|
The DTD |
|
|
|
|
|
|
This function is overloaded. The specific forms of functionality are described along with the syntax declarations.
Returns the qualified name of the DOMATTR (See Also: DOMAttr Subprograms):
DBMS_XMLDOM.GETQUALIFIEDNAME( a IN DOMATTR) RETURN VARCHAR2;
Returns the qualified name of the DOMElement (See Also: DOMElement Subprograms):
DBMS_XMLDOM.GETQUALIFIEDNAME( elem IN DOMELEMENT) RETURN VARCHAR2;
This function retrieves the schema URI associated with the node.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.GETSCHEMANODE( n IN DOMNODE) RETURN DOMNODE;
If this attribute was explicitly given a value in the original document, this is true; otherwise, it is false.
See Also:
DOMAttr SubprogramsDBMS_XMLDOM.GETSPECIFIED( a IN DOMATTR) RETURN BOOLEAN;
This function returns the standalone property associated with the DOMDOCUMENT.
See Also:
DOMDocument SubprogramsDBMS_XMLDOM.GETSTANDALONE( doc IN DOMDOCUMENT) RETURN VARCHAR2;
This function is overloaded. The specific forms of functionality are described along with the syntax declarations.
Returns the system id of the given DTD (See Also: DOMDocumentType Subprograms):
DBMS_XMLDOM.GETSYSTEMID( dt IN DOMDOCUMENTTYPE) RETURN VARCHAR2;
Returns the system identifier of the DOMENTITY (See Also: DOMEntity Subprograms):
DBMS_XMLDOM.GETSYSTEMID( ent IN DOMENTITY) RETURN VARCHAR2;
Returns the system identifier of the DOMNOTATION (See Also: DOMNotation Subprograms):
DBMS_XMLDOM.GETSYSTEMID( n IN DOMNOTATION) RETURN VARCHAR2;
Table 125-77 GETSYSTEMID Function Parameters
| Parameter | Description |
|---|---|
|
|
The DTD. |
|
|
|
|
|
|
This function returns the name of the DOMELEMENT.
See Also:
DOMElement SubprogramsDBMS_XMLDOM.GETTAGNAME( elem IN DOMELEMENT) RETURN VARCHAR2;
This function retrieves the value of the attribute.
See Also:
DOMAttr SubprogramsDBMS_XMLDOM.GETVALUE( a IN DOMATTR) RETURN VARCHAR2;
This function returns the version of the DOMDOCUMENT.
See Also:
DOMDocument SubprogramsDBMS_XMLDOM.GETVERSION( doc IN DOMDOCUMENT) RETURN VARCHAR2;
This function returns the XMLType associated with the DOMDOCUMENT.
See Also:
DOMDocument SubprogramsDBMS_XMLDOM.GETXMLTYPE( doc IN DOMDOCUMENT) RETURN SYS.XMLTYPE;
Verifies whether an attribute has been defined for DOMELEMENT, or has a default value.
See Also:
DOMElement SubprogramsVerifies whether an attribute with the specified name has been defined for DOMElement:
DBMS_XMLDOM.HASATTRIBUTE( elem IN DOMELEMENT, name IN VARCHAR2) RETURN VARCHAR2;
Verifies whether an attribute with specified name and namespace URI has been defined for DOMELEMENT; namespace enabled:
DBMS_XMLDOM.HASATTRIBUTE( elem IN DOMELEMENT, name IN VARCHAR2, ns IN VARCHAR2) RETURN VARCHAR2;
Table 125-82 HASATTRIBUTE Function Parameters
| Parameter | Description |
|---|---|
|
|
The |
|
|
Attribute name; * matches any attribute |
|
|
Namespace |
This function returns whether this node has any attributes.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.HASATTRIBUTES( n IN DOMNODE) RETURN BOOLEAN;
This function determines whether this node has any children.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.HASCHILDNODES( n IN DOMNODE) RETURN BOOLEAN;
This function tests if the DOMIMPLEMENTATION implements a specific feature.
See Also:
DOMImplementation SubprogramsDBMS_XMLDOM.HASFEATURE( di IN DOMIMPLEMENTATION, feature IN VARCHAR2, version IN VARCHAR2) RETURN BOOLEAN;
Table 125-85 HASFEATURE Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
The feature to check for |
|
|
The version of the DOM to check in |
This function imports a node from an external document and returns this new node.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.IMPORTNODE( doc IN DOMDOCUMENT, importedNode IN DOMNODE, deep IN BOOLEAN) RETURN DOMNODE;
Table 125-86 IMPORTNODE Function Parameters
| Parameter | Description |
|---|---|
|
|
Document from which the node is imported |
|
|
Node to import |
|
|
Setting for recursive import.
|
This function inserts the node newchild before the existing child node refchild. If refchild is NULL, insert newchild at the end of the list of children.
If newchild is a DOCUMENTFRAGMENT object, all of its children are inserted, in the same order, before refchild. If the newchild is already in the tree, it is first removed.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.INSERTBEFORE( n IN DOMNODE, newchild IN DOMNODE, refchild IN DOMNODE) RETURN DOMNode;
Table 125-87 INSERTBEFORE Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
The child to be inserted in the |
|
|
The reference node before which the |
This procedure inserts a string at the specified character offset.
See Also:
DOMCharacterData SubprogramsDBMS_XMLDOM.INSERTDATA( cd IN DOMCHARACTERDATA, offset IN NUMBER, arg IN VARCHAR2);
Table 125-88 INSERTDATA Procedure Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
The offset at which to insert the data |
|
|
The value to be inserted |
This function is overloaded. The specific forms of functionality are described along with the syntax declarations.
Checks if the given DOMNODE is NULL. Returns TRUE if it is NULL, FALSE otherwise (See Also: DOMNode Subprograms):
DBMS_XMLDOM.ISNULL( n IN DOMNODE) RETURN BOOLEAN;
Checks that the given DOMATTR is NULL; returns TRUE if it is NULL, FALSE otherwise (See Also: DOMAttr Subprograms):
DBMS_XMLDOM.ISNULL( a IN DOMATTR) RETURN BOOLEAN;
Checks that the given DOMCDATASECTION is NULL; returns TRUE if it is NULL, FALSE otherwise (See Also: DOMCDataSection Subprograms):
DBMS_XMLDOM.ISNULL( cds IN DOMCDATASECTION) RETURN BOOLEAN;
Checks that the given DOMCHARACTERDATA is NULL; returns TRUE if it is NULL, FALSE otherwise (See Also: DOMCharacterData Subprograms):
DBMS_XMLDOM.ISNULL( cd IN DOMCHARACTERDATA) RETURN BOOLEAN;
Checks that the given DOMCOMMENT is NULL; returns TRUE if it is NULL, FALSE otherwise (See Also: DOMComment Subprograms):
DBMS_XMLDOM.ISNULL( com IN DOMCOMMENT) RETURN BOOLEAN;
Checks that the given DOMDOCUMENT is NULL; returns TRUE if it is NULL, FALSE otherwise (See Also: DOMDocument Subprograms):
DBMS_XMLDOM.ISNULL( doc IN DOMDOCUMENT) RETURN BOOLEAN;
Checks that the given DOMDOCUMENTFRAGMENT is NULL; returns TRUE if it is NULL, FALSE otherwise (See Also: DOMDocumentFragment Subprograms):
DBMS_XMLDOM.ISNULL( df IN DOMDOCUMENTFRAGMENT) RETURN BOOLEAN;
Checks that the given DOMDOCUMENTTYPE is NULL; returns TRUE if it is NULL, FALSE otherwise (See Also: DOMDocumentType Subprograms):
DBMS_XMLDOM.ISNULL( dt IN DOMDOCUMENTTYPE) RETURN BOOLEAN;
Checks that the given DOMELEMENT is NULL; returns TRUE if it is NULL, FALSE otherwise (See Also: DOMElement Subprograms):
DBMS_XMLDOM.ISNULL( elem IN DOMELEMENT) RETURN BOOLEAN;
Checks that the given DOMENTITY is NULL; returns TRUE if it is NULL, FALSE otherwise (See Also: DOMEntity Subprograms):
DBMS_XMLDOM.ISNULL( ent IN DOMENTITY) RETURN BOOLEAN;
Checks that the given DOMENTITYREFERENCE is NULL; returns TRUE if it is NULL, FALSE otherwise (See Also: DOMEntityReference Subprograms):
DBMS_XMLDOM.ISNULL( EREF IN DOMENTITYREFERENCE) RETURN BOOLEAN;
Checks that the DOMIMPLEMENTATION is NULL; returns TRUE if it is NULL (See Also: DOMImplementation Subprograms):
DBMS_XMLDOM.ISNULL( di IN DOMIMPLEMENTATION) RETURN BOOLEAN;
Checks that the given DOMNAMEDNODEMAP is NULL; returns TRUE if it is NULL, FALSE otherwise (See Also: DOMNamedNodeMap Subprograms):
DBMS_XMLDOM.ISNULL( nnm IN DOMNAMEDNODEMAP) RETURN BOOLEAN;
Checks that the given DOMNODELIST is NULL; returns TRUE if it is NULL, FALSE otherwise (See Also: DOMNodeList Subprograms):
DBMS_XMLDOM.ISNULL( nl IN DOMNODELIST) RETURN BOOLEAN;
Checks that the given DOMNOTATION is NULL; returns TRUE if it is NULL, FALSE otherwise (See Also: DOMNotation Subprograms):
DBMS_XMLDOM.ISNULL( n IN DOMNOTATION) RETURN BOOLEAN;
Checks that the given DOMPROCESSINGINSTRUCTION is NULL; returns TRUE if it is (See Also: DOMProcessingInstruction Subprograms):
DBMS_XMLDOM.ISNULL( pi IN DOMPROCESSINGINSTRUCTION) RETURN BOOLEAN;
Checks that the given DOMTEXT is NULL; returns TRUE if it is NULL, FALSE otherwise (See Also: DOMText Subprograms):
DBMS_XMLDOM.ISNULL( t IN DOMTEXT) RETURN BOOLEAN;
Table 125-89 ISNULL Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
This function is overloaded. The specific forms of functionality are described along with the syntax declarations.
Returns the item in the map which corresponds to the INDEX parameter. If INDEX is greater than or equal to the number of nodes in this map, this returns NULL (See Also: DOMNamedNodeMap Subprograms):
DBMS_XMLDOM.ITEM( nnm IN DOMNAMEDNODEMAP, index IN NUMBER) RETURN DOMNODE;
Returns the item in the collection which corresponds to the INDEX parameter. If index is greater than or equal to the number of nodes in the list, this returns NULL (See Also: DOMNodeList Subprograms):
DBMS_XMLDOM.ITEM( nl IN DOMNODELIST, index IN NUMBER) RETURN DOMNODE;
Table 125-90 ITEM Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
The index in the node map at which the item is to be retrieved |
|
|
|
|
|
The index in the |
This function casts a given DOMNODE to a DOMATTR, and returns the DOMATTR.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.MAKEATTR( n IN DOMNODE) RETURN DOMATTR;
This function casts a given DOMNODE to a DOMCDATASECTION.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.MAKECDATASECTION( n IN DOMNODE) RETURN DOMCDATASECTION;
This function casts a given DOMNODE to a DOMCHARACTERDATA, and returns the DOMCHARACTERDATA.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.MAKECHARACTERDATA( n IN DOMNode) RETURN DOMCharacterData;
This function casts a given DOMNODE to a DOMCOMMENT, and returns the DOMCOMMENT.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.MAKECOMMENT( n IN DOMNODE) RETURN DOMCOMMENT;
This function casts a given DOMNODE to a DOMDOCUMENT, and returns the DOMDOCUMENT.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.MAKEDOCUMENT( n IN DOMNODE) RETURN DOMDocument;
This function casts a given DOMNODE to a DOMDOCUMENTFRAGMENT, and returns the DOMDOCUMENTFRAGMENT.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.MAKEDOCUMENTFRAGMENT( n IN DOMNODE) RETURN DOMDOCUMENTFRAGMENT;
This function casts a given DOMNODE to a DOMDOCUMENTTYPE and returns the DOMDOCUMENTTYPE.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.MAKEDOCUMENTTYPE( n IN DOMNODE) RETURN DOMDOCUMENTTYPE;
This function casts a given DOMNODE to a DOMELEMENT, and returns the DOMELEMENT.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.MAKEELEMENT( n IN DOMNODE) RETURN DOMELEMENT;
This function casts a given DOMNODE to a DOMENTITY, and returns the DOMENTITY.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.MAKEENTITY( n IN DOMNODE) RETURN DOMENTITY;
This function casts a given DOMNODE to a DOMENTITYREFERENCE, and returns the DOMENTITYREFERENCE.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.MAKEENTITYREFERENCE( n IN DOMNODE) RETURN DOMENTITYREFERENCE;
This function is overloaded. The specific forms of functionality are described along with the syntax declarations.
Casts given DOMATTR to a DOMNODE, and returns the DOMNODE (See Also: DOMAttr Subprograms):
DBMS_XMLDOM.MAKENODE( a IN DOMATTR) RETURN DOMNODE;
Casts the DOMCDATASECTION to a DOMNODE, and returns that DOMNODE (See Also: DOMCDataSection Subprograms):
DBMS_XMLDOM.MAKENODE( cds IN DOMCDATASECTION) RETURN DOMNODE;
Casts the given DOMCHARACTERDATA as a DOMNODE, and returns that DOMNODE (See Also: DOMCharacterData Subprograms):
DBMS_XMLDOM.MAKENODE( cd IN DOMCHARACTERDATA) RETURN DOMNODE;
Casts the given DOMCOMMENT to a DOMNODE, and returns that DOMNODE (See Also: DOMComment Subprograms):
DBMS_XMLDOM.MAKENODE( com IN DOMCOMMENT) RETURN DOMNODE;
Casts the DOMDOCUMENT to a DOMNODE, and returns that DOMNODE (See Also: DOMDocument Subprograms):
DBMS_XMLDOM.MAKENODE( doc IN DOMDOCUMENT) RETURN DOMNODE;
Casts the given DOMDOCUMENTFRAGMENT to a DOMNODE, and returns that DOMNODE (See Also: DOMDocumentFragment Subprograms):
DBMS_XMLDOM.MAKENODE( df IN DOMDOCUMENTFRAGMENT) RETURN DOMNode;
Casts the given DOMDOCUMENTTYPE to a DOMNODE, and returns that DOMNODE (See Also: DOMDocumentType Subprograms):
DBMS_XMLDOM.MAKENODE( dt IN DOMDOCUMENTTYPE) RETURN DOMNODE;
Casts the given DOMELEMENT to a DOMNODE, and returns that DOMNODE (See Also: DOMElement Subprograms):
DBMS_XMLDOM.MAKENODE( elem IN DOMELEMENT) RETURN DOMNODE;
Casts given DOMENTITY to a DOMNODE, and returns that DOMNODE (See Also: DOMEntity Subprograms):
DBMS_XMLDOM.MAKENODE( ent IN DOMENTITY) RETURN DOMNODE;
Casts the DOMENTITYREFERENCE to a DOMNODE, and returns that DOMNODE (See Also: DOMEntityReference Subprograms):
DBMS_XMLDOM.MAKENODE( eref IN DOMENTITYREFERENCE) RETURN DOMNODE;
Casts the DOMNOTATION to a DOMNODE, and returns that DOMNODE (See Also: DOMNotation Subprograms):
DBMS_XMLDOM.MAKENODE( n IN DOMNOTATION) RETURN DOMNODE;
Casts the DOMPROCESSINGINSTRUCTION to a DOMNODE, and returns the DOMNODE (See Also: DOMProcessingInstruction Subprograms):
DBMS_XMLDOM.MAKENODE( pi IN DOMPROCESSINGINSTRUCTION) RETURN DOMNODE;
Casts the DOMTEXT to a DOMNODE, and returns that DOMNODE (See Also: DOMText Subprograms):
DBMS_XMLDOM.MAKENODE( t IN DOMTEXT) RETURN DOMNODE;
Table 125-101 MAKENODE Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
t |
|
This function casts a given DOMNODE to a DOMNOTATION, and returns the DOMNOTATION.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.MAKENOTATION( n IN DOMNODE) RETURN DOMNOTATION;
This function casts a given DOMNODE to a DOMPROCESSINGINSTRUCTION, and returns the Domprocessinginstruction.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.MAKEPROCESSINGINSTRUCTION( n IN DOMNODE) RETURN DOMPROCESSINGINSTRUCTION;
This function casts a given DOMNODE to a DOMTEXT, and returns the DOMTEXT.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.MAKETEXT( n IN DOMNODE) RETURN DOMTEXT;
This function returns a new DOMDOCUMENT instance.
See Also:
DOMDocument SubprogramsReturns a new DOMDOCUMENT instance:
DBMS_XMLDOM.NEWDOMDOCUMENT RETURN DOMDOCUMENT;
Returns a new DOMDOCUMENT instance created from the specified XMLType object:
DBMS_XMLDOM.NEWDOMDOCUMENT( xmldoc IN SYS.XMLTYPE) RETURN DOMDOCUMENT;
Returns a new DOMDOCUMENT instance created from the specified CLOB:
DBMS_XMLDOM.NEWDOMDOCUMENT( cl IN CLOB) RETURN DOMDOCUMENT;
Table 125-105 NEWDOMDOCUMENT Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
|
This procedure normalizes the text children of the DOMELEMENT.
See Also:
DOMElement SubprogramsDBMS_XMLDOM.NORMALIZE( elem IN DOMELEMENT);
This procedure removes an attribute from the DOMELEMENT by name.
See Also:
DOMElement SubprogramsRemoves the value of a DOMELEMENT's attribute by name:
DBMS_XMLDOM.REMOVEATTRIBUTE( elem IN DOMELEMENT, name IN VARCHAR2);
Removes the value of a DOMELEMENT's attribute by name and namespace URI.
DBMS_XMLDOM.REMOVEATTRIBUTE( elem IN DOMELEMENT, name IN VARCHAR2, ns IN VARCHAR2);
Table 125-107 REMOVEATTRIBUTE Procedure Parameters
| Parameter | Description |
|---|---|
|
|
The |
|
|
Attribute name |
|
|
Namespace |
This function removes the specified attribute node from the DOMELEMENT. The method returns the removed node.
See Also:
DOMElement SubprogramsDBMS_XMLDOM.REMOVEATTRIBUTENODE( elem IN DOMELEMENT, oldAttr IN DOMATTR) RETURN DOMAttr;
Table 125-108 REMOVEATTRIBUTENODE Function Parameters
| Parameter | Description |
|---|---|
|
|
The |
|
|
The old |
This function removes the child node indicated by oldchild from the list of children, and returns it.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.REMOVECHILD( n IN DOMNode, oldchild IN DOMNode) RETURN DOMNODE;
Table 125-109 REMOVECHILD Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
The child of the node |
This function removes from the map a node specified by name, and returns this node. When this map contains the attributes attached to an element, if the removed attribute is known to have a default value, an attribute immediately appears containing the default value as well as the corresponding namespace URI, local name, and prefix when applicable.
See Also:
DOMNamedNodeMap SubprogramsRemoves a node specified by name:
DBMS_XMLDOM.REMOVENAMEDITEM( nnm IN DOMNamedNodeMap, name IN VARCHAR2) RETURN DOMNode;
Removes a node specified by name and namespace URI:
DBMS_XMLDOM.REMOVENAMEDITEM( nnm IN DOMNamedNodeMap, name IN VARCHAR2, ns IN VARCHAR2) RETURN DOMNode;
Table 125-110 REMOVENAMEDITEM Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
The name of the item to be removed from the map |
|
|
Namespace |
This function replaces the child node oldchild with newchild in the list of children, and returns the oldchild node. If newchild is a DocumentFragment object, oldchild is replaced by all of the DocumentFragment children, which are inserted in the same order. If the newchild is already in the tree, it is first removed.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.REPLACECHILD( n IN DOMNode, newchild IN DOMNode, oldchild IN DOMNode) RETURN DOMNode;
Table 125-111 REPLACECHILD Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
The new child which is to replace the old child |
|
|
The child of the node n which is to be replaced |
This procedure changes a range of characters in the node. Upon success, data and length reflect the change.
See Also:
DOMCharacterData SubprogramsDBMS_XMLDOM.REPLACEDATA( cd IN DOMCHARACTERDATA, offset IN NUMBER, cnt IN NUMBER, arg IN VARCHAR2);
Table 125-112 REPLACEDATA Procedure Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
The offset at which to replace |
|
|
The number of characters to replace |
|
|
The value to replace with |
This function resolves the given namespace prefix, and returns the resolved namespace.
See Also:
DOMElement SubprogramsDBMS_XMLDOM.RESOLVENAMESPACEPREFIX( elem IN DOMELEMENT, prefix IN VARCHAR2) RETURN VARCHAR2;
Table 125-113 RESOLVENAMESPACEPREFIX Function Parameters
| Parameter | Description |
|---|---|
|
|
The |
|
|
Namespace prefix |
Sets the value of a DOMELEMENT's attribute by name.
See Also:
DOMElement SubprogramsSets the value of a DOMELEMENT's attribute by name:
DBMS_XMLDOM.SETATTRIBUTE( elem IN DOMELEMENT, name IN VARCHAR2, value IN VARCHAR2);
Sets the value of a DOMElement's attribute by name and namespace URI:
DBMS_XMLDOM.SETATTRIBUTE( elem IN DOMELEMENT, name IN VARCHAR2, value IN VARCHAR2, ns IN VARCHAR2);
Table 125-114 SETATTRIBUTE Function Parameters
| Parameter | Description |
|---|---|
|
|
The |
|
|
Attribute name |
|
|
Attribute value |
|
|
Namespace |
Adds a new attribute node to the DOMELEMENT.
See Also:
DOMElement SubprogramsAdds a new attribute node to the DOMELEMENT:
DBMS_XMLDOM.SETATTRIBUTENODE( elem IN DOMELEMENT, newAttr IN DOMATTR) RETURN DOMATTR;
Adds a new attribute node to the DOMElement; namespace enabled:
DBMS_XMLDOM.SETATTRIBUTENODE( elem IN DOMELEMENT, newAttr IN DOMATTR, ns IN VARCHAR2) RETURN DOMATTR;
Table 125-115 SETATTRIBUTENODE Function Parameters
| Parameter | Description |
|---|---|
|
|
The |
|
|
The new |
|
|
The namespace |
This procedure is overloaded. The specific forms of functionality are described along with the syntax declarations.
Sets the character data of the node that implements this interface (See Also: DOMCharacterData Subprograms):
DBMS_XMLDOM.SETDATA( cd IN DOMCHARACTERDATA, data IN VARCHAR2);
Sets the content data of the DOMPROCESSINGINSTRUCTION (See Also: DOMProcessingInstruction Subprograms):
DBMS_XMLDOM.SETDATA( pi IN DOMPROCESSINGINSTRUCTION, data IN VARCHAR2);
Table 125-116 SETDATA Procedure Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
The data to which the node is set |
|
|
|
|
|
New processing instruction content data |
Given a DOM document, this procedure creates a new DTD with the given name, system id and public id and sets it in the document. This DTD can later be retrieved using the GETDOCTYPE Function.
DBMS_XMLDOM.SETDOCTYPE( doc IN DOMDocument, name IN VARCHAR2, sysid IN VARCHAR2, pubid IN VARCHAR2);
Table 125-117 SETDOCTYPE Procedure Parameters
| Parameter | Description |
|---|---|
|
|
The document whose DTD has to be set |
|
|
The name that the doctype needs to be initialized with |
|
|
The system ID that the doctype needs to be initialized with |
|
|
The public ID that the doctype needs to be initialized with |
This function adds a node using its NodeName attribute. If a node with that name is already present in this map, it is replaced by the new one. The old node is returned on replacement; if no replacement is made, NULL is returned.
As the NodeName attribute is used to derive the name under which the node must be stored, multiple nodes of certain types, those that have a "special" string value, cannot be stored because the names would clash. This is seen as preferable to allowing nodes to be aliased.
See Also:
DOMNamedNodeMap SubprogramsAdds a node using its NodeName attribute:
DBMS_XMLDOM.SETNAMEDITEM( nnm IN DOMNAMEDNODEMAP, arg IN DOMNODE) RETURN DOMNode;
Adds a node using its NodeName attribute and namespace URI:
DBMS_XMLDOM.SETNAMEDITEM( nnm IN DOMNAMEDNODEMAP, arg IN DOMNODE, ns IN VARCHAR2) RETURN DOMNode;
Table 125-118 SETNAMEDITEM Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
The Node to be added using its |
|
|
Namespace |
This procedure sets the value of this node, depending on its type. When it is defined to be NULL, setting it has no effect.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.SETNODEVALUE( n IN DOMNODE, nodeValue IN VARCHAR2);
Table 125-119 SETNODEVALUE Procedure Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
The value to which node is set |
This procedure sets the namespace prefix for this node to the given value.
See Also:
DOMNode SubprogramsDBMS_XMLDOM.SETPREFIX( n IN DOMNODE, prefix IN VARCHAR2);
Table 125-120 SETPREFIX Procedure Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
The value for the namespace prefix of the node |
This procedure sets the standalone property of the DOMDOCUMENT.
See Also:
DOMDocument SubprogramsDBMS_XMLDOM.SETSTANDALONE( doc IN DOMDOCUMENT, newvalue IN VARCHAR2);
Table 125-121 SETSTANDALONE Procedure Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
Value of the standalone property of the document |
This procedure sets the value of the attribute.
See Also:
DOMAttr SubprogramsDBMS_XMLDOM.SETVALUE( a IN DOMATTR, value IN VARCHAR2);
Table 125-122 SETVALUE Procedure Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
The value to which to set the attribute |
This procedure sets the version of the DOMDOCUMENT.
See Also:
DOMDocument SubprogramsDBMS_XMLDOM.SETVERSION( doc IN DOMDOCUMENT, version IN VARCHAR2);
Table 125-123 SETVERSION Procedure Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
The version of the document |
This function breaks this DOMTEXT node into two DOMTEXT nodes at the specified offset.
See Also:
DOMText SubprogramsDBMS_XMLDOM.SPLITTEXT( t IN DOMTEXT, offset IN NUMBER) RETURN DOMText;
Table 125-124 SPLITTEXT Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
Offset at which to split |
This function extracts a range of data from the node.
See Also:
DOMCharacterData SubprogramsDBMS_XMLDOM.SUBSTRINGDATA( cd IN DOMCHARACTERDATA, offset IN NUMBER, cnt IN NUMBER) RETURN VARCHAR2;
Table 125-125 SUBSTRINGDATA Function Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
The starting offset of the data from which to get the data |
|
|
The number of characters (from the offset) of the data to get |
This procedure is overloaded. The specific forms of functionality are described along with the syntax declarations.
Writes XML node to specified buffer using the database character set (See Also: DOMNode Subprograms):
DBMS_XMLDOM.WRITETOBUFFER( n IN DOMNODE, buffer IN OUT VARCHAR2);
Writes XML document to a specified buffer using database character set (See Also: DOMDocument Subprograms):
DBMS_XMLDOM.WRITETOBUFFER( doc IN DOMDOCUMENT, buffer IN OUT VARCHAR2);
Writes the contents of the specified document fragment into a buffer using the database character set (See Also: DOMDocumentFragment Subprograms):
DBMS_XMLDOM.WRITETOBUFFER( df IN DOMDOCUMENTFRAGMENT, buffer IN OUT VARCHAR2);
Table 125-126 WRITETOBUFFER Procedure Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
Buffer to which to write |
|
|
|
|
|
DOM document fragment |
This procedure is overloaded. The specific forms of functionality are described along with the syntax declarations.
Writes XML node to specified CLOB using the database character set (See Also: DOMNode Subprograms):
DBMS_XMLDOM.WRITETOCLOB( n IN DOMNODE, cl IN OUT CLOB);
Writes XML document to a specified CLOB using database character set (See Also: DOMDocument Subprograms):
DBMS_XMLDOM.WRITETOCLOB( doc IN DOMDOCUMENT, cl IN OUT CLOB);
Table 125-127 WRITETOCLOB Procedure Parameters
| Parameter | Description |
|---|---|
|
|
|
|
|
|
|
|
|
This procedure is overloaded. The specific forms of functionality are described along with the syntax declarations.
Writes XML node to specified file using the database character set (See Also: DOMNode Subprograms):
DBMS_XMLDOM.WRITETOFILE( n IN DOMNODE, fileName IN VARCHAR2);
Writes XML node to specified file using the given character set, which is passed in as a separate parameter (See Also: DOMNode Subprograms):
DBMS_XMLDOM.WRITETOFILE( n IN DOMNODE, fileName IN VARCHAR2, charset IN VARCHAR2);
Writes an XML document to a specified file using database character set (See Also: DOMDocument Subprograms):
DBMS_XMLDOM.WRITETOFILE( doc IN DOMDOCUMENT, filename IN VARCHAR2);
Writes an XML document to a specified file using given character set (See Also: DOMDocument Subprograms):
DBMS_XMLDOM.WRITETOFILE( doc IN DOMDOCUMENT, fileName IN VARCHAR2, charset IN VARCHAR2);