Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

apex_data_export.download not prompting

MegamanXNov 24 2022

I'm using this code but getting no file on the browser.
The log even says Starting Download of "repot.csv"

DECLARE
    l_export       apex_data_export.t_export;
    l_region_id    number;
BEGIN

   SELECT region_id into l_region_id
     FROM apex_application_page_regions
    WHERE application_id = 100
      and page_id = 3
      and static_id = 'classic_report';
    
    l_export := apex_region.export_data (
         p_format       => apex_data_export.c_format_html,
         p_page_id      => 3,
         p_region_id    => l_region_id );
         
    apex_data_export.download( l_export );
END;
This post has been answered by MegamanX on Nov 28 2022
Jump to Answer

Comments

SriniVEERAVALLI
Answer
Try IFNULL(expr, value)
for other column

"Fact - OLB Processed Invoices"."Invoice Amount - Functional Currency"+IFNULL("Fact - OLB Processed Invoices"."AR Tax Amount - Invoice Currency",0)

Edited by: Srini VEERAVALLI on Mar 20, 2013 10:02 AM
Marked as Answer by 994691 · Sep 27 2020
994691
Hi veeravalli ,
Thanks, I was trying for the same. But there was a problem with the server,I have restarted it,and now it is working. Thanks a lot.
1 - 2

Post Details

Added on Nov 24 2022
1 comment
928 views