My Oracle Support Banner

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

Last updated on JANUARY 10, 2020

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.