How Can You Send Multiple Queries To Dbms_xmlgen.getxml (Doc ID 2034434.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Goal

Provide additional information to the user on how to pass multiple queries to dbms_xmlgen.getxml.

Using an APEX application to send XML to BI Publisher. Because of the size of images in XML, I've got to use the dbms_xmlgen.getxml procedure to send the data, instead of using the built into APEX 'Report Queries' and "Report Layouts'.

dbms_xmlgen.getxml, when passed a query, will return a single XML rowset/row result set.

In APEX you can build a Report Query with MULTIPLE queries which will return MULTIPLE rowset/row result sets. Since we can't use the build in APEX functionality, I'm wondering how I would do this directly using the dbms_xmlgen.getxml procedure.

For example, using the following two queries in the APEX Report Queries gives me the multiple query sample xml (uploaded).

select * from hr.employees where rownum < 3;
select * from hr.departments where rownum < 3;

I'd like to do the same thing in my own using dbms_xmlgen.getxml.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms