How Can You Send Multiple Queries To Dbms_xmlgen.getxml
Last updated on JUNE 22, 2017
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms