t = window.open('/d/?random='+Math.round(Math.random()*900000000));       
t.focus();

declare
  l_text_html varchar2(4000);
Begin
  owa_util.mime_header( 'application/octet', FALSE );
  htp.p('Content-Disposition: attachment; filename="emp.csv"');
  owa_util.http_header_close;
   htp.prn('ssssssssssssssssssss ASSSSSSSSSSSSSSS');
  -- Send an error code so that the
  -- rest of the HTML does not render
  htmldb_application.g_unrecoverable_error := true;
exception
  when others then
  htp.prn('Системная ошибка AJAX в AppProcess');
end;

t = window.open('','','width=200,height=100');
t.document.write("<p>" + ajaxRes + "</p>");
t.focus();

<div onclick="downloadimg('1.jpg')"></div>
function downloadimg(img) {
document.location='1.php?i='+img;
}

  htp.p('Content-Length: ' || dbms_lob.getlength(blobOutput));
  htp.p('Cache-Control: "no-cache"');  
  htp.p('');
  wpg_docload.download_file(blobOutput);

  htp.p('Content-Length: 6');
  htp.p('Cache-Control: "no-cache"');  
  htp.p('');
  wpg_docload.download_file('АВС');

-- Application Process
=================
declare
  l_csv blob;
  l_row varchar2(32767);
Begin
  dbms_lob.createTemporary(l_csv, TRUE);
  dbms_lob.open(l_csv, dbms_lob.lob_readwrite);  
  for i in 1..4
  loop
    l_row := '1234';
    l_row := l_row||chr(10);
    dbms_lob.writeappend(l_csv,length(l_row),utl_raw.cast_to_raw(l_row));
  end loop;
  dbms_lob.close(l_csv);
  
  htp.p('Content-Type: application/csv; charset=UTF-8');
  htp.p('Content-Disposition: attachment; filename=PriceTemplate.csv;');
  htp.p('Content-Length: ' || dbms_lob.getlength(l_csv));
  htp.p('Cache-Control: "no-cache"');  
  htp.p('');    
  wpg_docload.download_file(l_csv);  
  -- Send an error code so that the
  -- rest of the HTML does not render
  htmldb_application.g_unrecoverable_error := true;
exception
  when others then
  htp.prn('Системная ошибка AJAX в AppProcess');
end;

-- ЗАГОЛОВОК ЗАПРОСА
==================
Cache-Control	"no-cache"
Content-Disposition	attachment; filename=PriceTemplate.csv;
Content-Length	20
Content-Type	application/csv; charset=UTF-8
Server	Oracle XML DB/Oracle Database

-- Вызов в JS
=================
function getText(this_) {
  try {
    var ajaxReq = new htmldb_Get(null,&APP_ID.,'APPLICATION_PROCESS=TEST',0);
    ajaxRes = ajaxReq.get();
    if(ajaxRes)
      { 
        redirect(ajaxReq.url());
      }
      else
      {
        alert("AJAX - Sysytem Error");
      }
    ajaxReq = null;
  } catch (e)  
  {
    alert("SYS - Системная ошибка: " + e);
  }
};