I need to generate XML output from a PL/SQL procedure rather than from a simple query as described in the Oracle documentation. The procedure will return a combination of single values and tables. Does anyone have experience in this area? I'm using version 8i of Oracle.