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 22.214.171.124 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