export_util is wrapper package around apex_data_export.download to download a file in Oracle APEX

export_util.sql

create or replace package export_util as
   procedure download_file(
      file_name              in varchar2
    , mime_type              in varchar2                                default 'application/octet-stream'
    , content_blob           in blob
    , content_disposition    in apex_data_export.t_content_disposition  default apex_data_export.c_attachment
    , stop_apex_engine       in boolean                                 default true
   );

   procedure download_file(
      file_name              in varchar2
    , mime_type              in varchar2                                default 'application/octet-stream'
    , content_clob in clob
    , content_disposition    in apex_data_export.t_content_disposition  default apex_data_export.c_attachment
    , stop_apex_engine       in boolean                                 default true
   );
end export_util;

create or replace package body export_util as
   procedure download_file(
      file_name              in varchar2
    , mime_type              in varchar2                                default 'application/octet-stream'
    , content_blob           in blob
    , content_disposition    in apex_data_export.t_content_disposition  default apex_data_export.c_attachment
    , stop_apex_engine       in boolean                                 default true
   )
   is
      l_export apex_data_export.t_export := apex_data_export.t_export(
         file_name    => file_name
      , mime_type    => mime_type
      , content_blob => content_blob
      );
   begin
      apex_data_export.download(
         p_export => l_export
       , p_content_disposition => content_disposition
       , p_stop_apex_engine => stop_apex_engine
      );
   end download_file;

   procedure download_file(
      file_name              in varchar2
    , mime_type              in varchar2                                default 'application/octet-stream'
    , content_clob in clob
    , content_disposition    in apex_data_export.t_content_disposition  default apex_data_export.c_attachment
    , stop_apex_engine       in boolean                                 default true
   )
   is
      l_export apex_data_export.t_export := apex_data_export.t_export(
         file_name    => file_name
      , mime_type    => mime_type
      , as_clob      => true
      , content_clob => content_clob
      );
   begin
      apex_data_export.download(
         p_export => l_export
       , p_content_disposition => content_disposition
       , p_stop_apex_engine => stop_apex_engine
      );
   end download_file;
end export_util;