XML type

XMLType is supported and can still be used to a limited degree. It is possible to query XMLType columns as well as inserting data into them.

To query from an XMLType column, the getClobVal method of the XMLType object must be used.

Consider the table created by this statement:

CREATE TABLE MY_XML (myCol sys.xmltype)

The following query can be executed to get the XML data:

SELECT t.myCol.getClobVal() FROM MY_XML t

To insert into the table, you must use the createXML method. It is not possible to do this by creating a type tree for the table and using this tree in an output card. Instead, the INSERT statement should be executed through a DBLOOKUP.

The following is an example of the syntax of the SQL:

INSERT INTO MY_XML VALUES (sys.xmltype.createXML
(`<XMLDocument>cat</XMLDocument>'))

Oracle parses the XML document when it is inserted. Therefore, the above statement will fail if the XML is invalid.