Using Oracle XML Components to Generate XML Documents: PL/SQL

Figure 3-10 shows the Oracle XML PL/SQL components used to generate an XML document. Available XML PL/SQL components are:

• XDK for PL/SQL:
  • XML Parser for PL/SQL, Version 2 including XSLT

• XML-SQL Utility (XSU) for PL/SQL

In the PL/SQL environment, when a user or client or application sends a query (SQL), there are two possible ways of processing the query using the Oracle XML components:

• Directly via JDBC which then accesses the XML Parser

• Via XML-SQL Utility

Figure 3-10 Using Oracle XML Components to Generate an XML Document - PL/SQL Options