Oracle8i Application Developer's Guide - XML Release 3 (8.1.7) Part Number A86030-01 |
Library | Service | Contents | Index

Using XML-SQL Utility (XSU), 19 of 26

## Setting Stylesheets in XSU (PL/SQL)

The PL/SQL API provides the ability to set the stylesheet header in the result XML or apply a stylesheet itself to the result XML document, before generation. The latter is a huge performance win since otherwise the XML document has to be generated as a CLOB, sent to the parser again and then the stylesheet applied. In this case, internally the utility generates a DOM document, calls the parser, applies the stylesheet and then generates the result. The procedure `setStylesheetHeader`() sets the stylesheet header in the result. This simply adds the XML processing instruction to include the stylesheet. The `useStyleSheet`() procedure on the other hand uses the stylesheet to generate the result.

| Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
Library | Service | Contents | Index