SQL did not retrieve data in XML
Hi All,
Below is the data template XML loaded and ran the program with parameter 01-JAN-2016 and 10-JAN-2016.The request completed normally but the output shows only the name . I ran the query normally in TOAD and it gives records.
<?xml version="1.0" encoding="UTF-8"
?>
- <CPD_AP_PO_INV_REPORT>
<LIST_G_CPD_INVOICE_DETAILS />
</CPD_AP_PO_INV_REPORT>
- Below is the data template XML:
-------------------------------------------
Please let me know what might be the issue.
<?xml version="1.0" encoding="UTF-8" ?><!--========================================================================= --><!-- CPD AP INVOICE DETAILS--><!-- Chicago Park District --><!--========================================================================= --><!-- Name : CPD_AP_PO_INV_REPORT --><!-- Description : AP Invoice Payment Details Report--><!-- --><!-- --><!-- --><!-- --><!--Change Record: --><!--=============== --><!--Version Date Author Remarks --><!--======= ========== =============== ======================= --><!--1.0 03-MAY-2017 Harish Ventrapragada Initial version --><!--==========================================================================--><dataTemplate version="1.0" description="CPD_AP_INVOICE_DETAILS" name="CPD_AP_PO_INV_REPORT"><properties><property name="scalable_mode" value="on"/></properties><properties><property name="db_fetch_size" value="20"/></properties><properties>