Oracle XML DB Support

[ghyland]

I am wondering if much is planned for supporting the XML functionality of Oracle XML DB in release 2 and 10i versions of the database. I noticed that Oracle have had to adapt SQLPlus to work with Oracle XML DB when running in client/server mode.

I tried running the query:

select XDBUritype('/xdbconfig.xml').getXML()
from dual;

which produces an XML document in SQLPlus but nothing in PL/SQL Developer.

 

[Marco Kalter]

In 5.1 you will need to use the xmltype.getclobval() function to obtain the XML text from an XMLTYPE (see chapter 6.7 in the User's Guide: 6.7 Viewing and editing XMLTYPE columns). Note that only Oracle Net 9.2 and later directly support XMLTYPE, and this will be added in 6.0 as well.