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.