|Oracle8i Application Developer's Guide - XML
Release 3 (8.1.7)
Part Number A86030-01
Oracle XML Components and General FAQs, 9 of 18
Oracle XML-SQL Utility (XSU) supports Java and PL/SQL.
XML-SQL Utility Java classes can be used for the following tasks:
Figure 3-5 shows the Oracle XML-SQL Utility overall functionality.
XML SQL Utility for Java consists of a set of Java classes that perform the following tasks:
Figure 3-6 shows how XML SQL Utility processes SQL queries and returns the results as an XML document.
The structure of the resulting XML document is based on the internal structure of the database schema that returns the query results:
The XML-SQL Utility (XSU) generates either of the following:
You can also use the XML-SQL Utility (XSU) to generate a DTD based on the schema of the underlying table or view being queried. You can use the generated DTD as input to the XML Class Generator for Java or C++. This generates a set of classes based on the DTD elements. You can then write code that uses these classes to generate the infrastructure behind a web-based form. See also "XML Class Generator".
Based on this infrastructure, the web form can capture user data and create an XML document compatible with the database schema. This data can then be written directly to the corresponding database table or object view without further processing.
To write an XML document to a database table, where the XML data does not match the underlying table structure, transform the XML document before writing it to the database. For techniques on doing this, see Chapter 4, "Using XML-SQL Utility (XSU)".