create or replace function export_application(
  p_wsid  in number,
  p_appid in number
) return clob is
    nm  owa.vc_arr;
    vl  owa.vc_arr;

    l_exp_lcnt  number :=  2000000 ;
    l_exp_lines htp.htbuf_arr ;
    l_exp_all   clob;
begin
    nm( 1 ) := 'REMOTE_ADDR';
    vl( 1 ) := '1.2.3.4';
    owa.init_cgi_env( nm.count, nm, vl );
    htp.addDefaultHTMLHdr(false);
    --тут можно делать выгрузку по компонентам
    apex_util.export_application(p_wsid, p_appid);
    htp.get_page(l_exp_lines, l_exp_lcnt);
    dbms_lob.createtemporary(l_exp_all, true, dbms_lob.call);
    for i in  1 ..l_exp_lines.count  loop
      dbms_lob.writeappend(l_exp_all, length(l_exp_lines(i)), l_exp_lines(i));
    end loop;
    return l_exp_all;
end;

procedure export (
    -- This procedure exports flows
    --
    -- p_flow_id...................Unique ID number of your flow
    -- p_page_id...................Optional Page ID number
    -- p_format....................Output format UNIX, DOS, DB, XML
    -- p_commit....................Generate a commit statement at end of script (YES or NO)
    -- p_owner_override............Set the application owner to this USER and not the current flows owner attribute
    -- p_flashback_min_ago.........Set the export procedure to use flashback mode
    -- p_file_id...................Use optionally when exporting into DB format
    -- p_export_comments...........Export comments in with the file
    -- p_export_ir_public_reports..Export Public Interactive Reports
    -- p_export_ir_private_reports.Export Private Interactive Reports
    -- p_export_ir_notifications...Export Interactive Report Notification Settings
    -- p_debugging_override........Set the application debugging status to this value (1 = Yes, 0 = No)
    --
    p_flow_id                     in number,
    p_page_id                     in number   default null,
    p_format                      in varchar2 default 'UNIX',
    p_commit                      in varchar2 default 'YES',
    p_owner_override              in varchar2 default null,
    p_build_status_override       in varchar2 default 'NO',
    p_flashback_min_ago           in number   default null,
    p_file_id                     in number   default null,
    p_export_comments             in varchar2 default 'N',
    p_export_ir_public_reports    in varchar2 default 'N',
    p_export_ir_private_reports   in varchar2 default 'N',    
    p_export_ir_notifications     in varchar2 default 'N',
    p_debugging_override          in number   default null,
    p_component                   in varchar2 default null,
    p_component_id                in number   default null
    )
    ;