OTN

This page is a placeholder for informative discussions or demonstrations on the Oracle XMLDB Oracle Technet Forum pages. The different posts and questions are sorted by topic.

I am always lost regarding finding the page on the OTN XMLDB Forum, that I have read and / or commented on; I desperately need it now; because I know it contains the solution or starting point that I need…

General Topics

• OTN – XMLDB FAQ (Mark Drake)
• XMLDB mainpage on Oracle.com

Programming

• The Difference between extractvalue and extract().getCLOBVal explained (2006)
• Obtain a node name (2007)
• Using XDB for manipulating table BLOBS? (2007)
• FTP-ed document can not be read using XDBURITYPE because of ORA-31167
• 64K node limitation / avoiding XML parsing (2006)
• Position
• XMLType Performance (2008)
• Anton on the lose on DBMS_XMLDOM (2006/2010)
• Some XQuery methods/magic to flatten recursive XML tree (2011)

Handling CDATA

• How to fix the xml? (2008, How to handle CDATA within XML)

Utilities

• SQLLoader: Validating against an XML schema(2009)
• Validating against an XML schema (while using SQL*Loader – 2009)

Webservices / NDWS / WSDL

• Testing Protocol Server WSDL functionality (2007)
• 11g Native Web Services (2009)
• Info about Time, GIS and other usable XML(DB) Services
• Calling a Webservice via PL/SQL (2009)
• Feeding NDWS / Soap with XML Schema information, WSDL wise (2009)
• Creating a SOAP service that accepts a variable number of arguments (2009)
• XForms (2008)
• Mapping network drive to localhost, to access XMLDB repository on window 7

XBRL

• A great XBRL example (2007)
• 10g vs 11g xquery performance with XBRL (2007)

XSLT

• XMLTransform in 10gR2 stops returning data (2008 – MS Excel example)
• xmlType.transform() mangles < ?blah?> tags (2008)

XML Schema

• Generate XML Schema from oracle tables (2006)
• Namespace prefix not declared? (2007)
• ORA-31013: Invalid XPATH expression (2006, Namespace references)
• Type inheritance in XML schemas – good, bad, ugly ? (2006)
• Setting Attribute SQLInline to false for Out-of-Line Storage
• XML Schema Namespace resolution in XMLDB (2009)

XML Storage

• Creating manually xmltype storage objects / Indexing Columns (2006)
• XMLType view of Relational Content (2006)
• XMLType_table (2008, Partition XML by List)
• XML file processing into oracle (2010)
• Incorrect (interval) XML partitioning / ORA-02266 (2010)
• Handling Microsoft Office 2003 documents (2011)
• Inside in Structured XMLIndex handling (2011)

XML Performance

• Child node insert performance (2008)
• Advice for XML Annotations for a schema for metadata (2008)
• Inside in XPath tuning (2011)

XML DB Protocol Server

• HTTPS Configuration (2009)
• Enable the fast path FTP (10.2.0.4) via blockDefault=”#all” Schema tag
• How to change XDB http port to port 80?
• XMLIndex Value Index on repository (including XDB repository events)

XML Evolution

• Evolution example (2007)
• Problem in XSD and XSLT (2006)

The XMLDB Repository

• How is DefaultTable populated after dbms_xdb.createResource? (2007)
• A way to update create and modification time of a resource (2007)

XML Security

• ACL-Based Security and XML DB (2008)

XML NLS Issues

• Good example of NLS Characterset behavior, while working with XML

XQuery

• XMLQuery (XQuery) with namespace, handling Microsoft doc’s (2006)
• Date Range Querying Against XML Data (2007)
• Generation of Dynamic element names and attributes (2009)
• Good Example of extended use of XQuery (2011)

Pre – Oracle 9.2.0.3, XMLDB Solutions

• XML 8i (schemavalidation using a Java XML parser)
• Problem running XSQL page (2009)