Skip Headers

Oracle9i XML Database Developer's Guide - Oracle XML DB
Release 2 (9.2)

Part Number A96620-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page Go to next page
View PDF

What's New In Oracle XML DB?

This chapter describes the new features, enhancements, APIs, and product integration added through Oracle XML DB as a part of Oracle9i Release 2 ( and Oracle9i Release 2 (

Oracle XML DB: Oracle9i Release 2 ( Enhancements

This section summarizes the Oracle XML DB enhancements provided with patch release, Oracle9i Release 2 (

See Also:

Oracle9i Release Notes, Release 2 ( available with your software.

Exporting and Importing XML Data

Oracle9i Release 2 ( provides enhanced IMPORT/EXPORT utility support to assist in loading XML data into Oracle XML DB. See Chapter 23, "Importing and Exporting XMLType Tables".

XMLAgg() SQLX Function

XMLAgg() now supports the ORDER BY clause. See Chapter 10, "Generating XML Data from the Database", "XMLAgg() Function".

updateXML() XMLType Function

The updateXML() section has been reworked to include more comprehensive examples.

Globalization Support: Multibyte Characters

Oracle XML DB can handle multibyte characters as long as the client character set is the same as the database character set.

Updated Oracle XML DB - Supplied XML Schema

The end of Appendix G, "Example Setup scripts. Oracle XML DB - Supplied XML Schemas" lists the three updated Oracle XML DB - supplied XML schema, XDBResource.xsd, acl.xsd, and xdbconfig.xsd.

Migrating from Release 2 ( to Release 2 (

Notes have been adding describing how to migrate from Release 2 ( to Release 2 ( See Appendix A, "Installing and Configuring Oracle XML DB".


Further examples and explanation have been added to this section for determining paths under multiple correlations or specified path name arguments. See Chapter 15, "RESOURCE_VIEW and PATH_VIEW", "PATH".

New Configuration Parameters

A new tuning parameter, resource-view-cache-size has been added. When querying large RESOURCE_VIEWs you can now tune the resource-view-cache-size parameter in the xdbconfig file. See Chapter 15, "RESOURCE_VIEW and PATH_VIEW", "Tuning XML DB to Obtain Faster Queries".

HTTP/webDAV parameter default-url-charset has been added. This is the character set in which an HTTP Protocol Server assumes the incoming URL is encoded when it is not encoded in UTF-8 or the request's Content-Type field Charset parameter. See Chapter 19, "Using FTP, HTTP, and WebDAV Protocols", Table 19-3.

PL/SQL DOM API for XMLType: New Methods

Several new DBMS_XMLDOM methods are now supported for the PL/SQL DOM API for XMLType. See Chapter 8, "PL/SQL API for XMLType". Note that there are a few methods that have been de-supported in this release.

Java DOM API for XMLType: Desupported Methods

A few methods in XDBDocument, XDBNode, and XDBDOMImplementation classes have been de-supported in this release. See Chapter 9, "Java API for XMLType".

Highlight Support for XML Documents with INPATH/HASPTH Oracle Text Operators

You can now highlight XML documents in Oracle Text with the INPATH/HASPATH query element(s) highlighted and using CTX_DOC.MARKUP or HIGHLIGHT procedures. See Chapter 7, "Searching XML Data with Oracle Text", "Highlight Support for INPATH/HASPATH Text Operators".

Oracle XML DB Case Studies are Provided

See Chapter 25, "Oracle XML DB Case Study: Web Services Retrieve and Display XML Documents" and Chapter 26, "Oracle XML DB Basic Demo".

See Also: for the latest Oracle XML DB updates and notes.

Oracle XML DB, Oracle9i Release 2 ( XMLType Enhancements

XMLType datatype was first introduced in Oracle9i. This datatype has been significantly enhanced in Oracle9i Release 2 ( This release is also referred to, in general, as Release 2 (9.2). The following sections describe these enhancements.

See Also:

Oracle9i XML API Reference - XDK and Oracle XML DB

XMLType Tables

Datatype XMLType can now be used to create tables of XMLType. This gives you the flexibility to store XML either in a column, in a table, or as a whole table, much like objects.

XMLType Constructors

Additional XMLType constructors have been added. Besides the createXML() functions, XMLType can now also be constructed using user-defined constructors.

W3C XML Schema Support

Extensive XML schema support has been added in this release to Oracle XML DB. You can now perform the following:

SQLX Functions and Oracle Extensions

This release includes support for SQLX operations for generating XML from existing relational and object relational tables. This is based on ISO-ANSI Working Draft for XML-Related Specifications (SQL/XML) [ISO/IEC 9075 Part 14 and ANSI] which defines ways in which the database language SQL can be used in conjunction with XML.

For example, the following functions defined by the SQLX standards body are supported: XMLElement(), XMLForest(), XMLConcat(), and XMLAgg(). Oracle XML DB also extends the SQLX operations with functions such as: XMLColAttVal(), XMLSequence(), SYS_XMLGEN(), and SYS_XMLAGG().

W3C XPath Support for Extraction, Condition Checks, and Updates

Oracle9i Release 1 (9.0.1) provided the extract() and existsNode() functions on XMLType objects. These allowed XPath-based queries against XML documents. This release provides additional support as follows:

ToObject Method

ToObject method allows the caller to convert an XMLType object to a PL/SQL object type.

XMLType Views

This release supports XMLType-based views. These enable you to view any data in the database as XML. XMLType views can be XML schema-based or non-XML schema-based. See Chapter 11, "XMLType Views".

W3C XSLT Support

This release introduces a new function, XMLTransform() that allows for a database-based transformation of in-memory or on disk XML documents. See Chapter 6, "Transforming and Validating XMLType Data".

JDBC Support for XMLType

Oracle XML DB allows database clients to bind and define XMLType. JDBC support includes a function-rich XMLType class that allows for native (for thick JDBC) XML functionality support. See Chapter 9, "Java API for XMLType".

C-Based PL/SQL DOM, Parser, and XSLT APIs

This release includes native PL/SQL DOM, Parser, and XSLT APIs integrated in the database code. These PL/SQL APIs are compatible with the Java-based PLSQL APIs shipped as part of XDK for PL/SQL with Oracle9i Release 1 (9.0.1) and higher. See Chapter 8, "PL/SQL API for XMLType".

Oracle XML DB, Oracle9i Release 2 ( Repository

In this release, Oracle XML DB Repository adds advanced foldering and security mechanisms to the database. Oracle XML DB Repository is a new feature that provides a novel file system-like access to all database data. The Repository allows the following actions:

Oracle XML DB Resource API (PL/SQL): DBMS_XDB

DBMS_XDB package provides methods to access and manipulate Oracle XML DB resources. Chapter 16, "Oracle XML DB Resource API for PL/SQL (DBMS_XDB)".

Oracle XML DB Resource API (JNDI)

This uses JNDI (Java Naming and Directory Interface) to locate resources, and manage collections. It supports JNDI Service Provider Interface (SPI). This interface works only inside the database server on the JServer platform. See Chapter 17, "Oracle XML DB Resource API for Java".

Oracle XML DB Resource View API (SQL)

ResourceView is a public XMLType view that you can use to perform path name-based queries against all resources in a database instance. This view merges path-based queries with queries against relational and object-relational tables and views. See Chapter 15, "RESOURCE_VIEW and PATH_VIEW".

In Release 2 ( the XDBconfig file includes a tuning parameter, resource-view-cache-size to allow faster queries. See the end of Chapter 15, "RESOURCE_VIEW and PATH_VIEW".

Oracle XML DB Versioning: DBMS_XDB_VERSION

DBMS_XDB_VERSION package provides methods to version Oracle XML DB resources. See Chapter 14, "Oracle XML DB Versioning".

Oracle XML DB ACL Security

Methods that implement ACL-based security are a part of DBMS_XDB package. They allow you to create high-performance access control lists for any XMLType object. See Chapter 18, "Oracle XML DB Resource Security".

Oracle XML DB Protocol Servers

The Protocol Servers provide access to any foldered XMLType row through FTP, HTTP, and WebDAV. Note that XMLType can manage arbitrary binary data as well in any file format. See Chapter 19, "Using FTP, HTTP, and WebDAV Protocols".


URIType now includes a new subtype, XDBURIType, that represents a path name within Oracle XML DB. See Chapter 12, "Creating and Accessing Data Through URLs".

Oracle Tools Enhancements for Oracle XML DB

Oracle Enterprise Manager

Oracle Enterprise Manager provides a graphical interface to manage, administer, and configure Oracle XML DB. See Chapter 21, "Managing Oracle XML DB Using Oracle Enterprise Manager".

Oracle Text Enhancements

This release offers the following Oracle Text enhancements:

See Chapter 7, "Searching XML Data with Oracle Text".

Oracle Advanced Queuing (AQ) Support

With this release, the Advanced Queueing (AQ) Internet Data Access Presentation (IDAP) has been enhanced. IDAP facilitates your using AQ over the Internet. You can now use AQ XML servlet to access Oracle9i AQ using HTTP and SOAP.

Also in this release, IDAP is the Simple Object Access Protocol (SOAP) implementation for AQ operations. IDAP now defines the XML message structure used in the body of the SOAP request.

You can now use XMLType as the AQ payload type instead of having to embed XMLType as an attribute in an Oracle object type.


Oracle XDK Support for XMLType

XDK for Java Support

XSQL Servlet and XML SQL Utility (XSU) for Java now support XMLType. Most methods on XMLType object, such as, getClobVal(), are now available in XSU for Java.

XDK for PLSQL Support

XML SQL Utility (XSU) for PLSQL now supports XMLType.