Download Text File With Unlimited Character

1. Make a Region with PL/SQL Dynamic Content  type .
==========
2. Assign ID to the region using  HTP.p (<span id="TEST_ID">) and Select data from table into  a  CLOB Type Variable  and Print the variable using HTP.p
==========
Example :

HTP.p ('<a download="Subject_Info.txt" id="downloadlink"  ><b>Download</b></a> <br> <br> <br>');  

DECLARE
  
   v_text     CLOB;
BEGIN
HTP.p ('<span id="TEST_ID">');      
      FOR i
         IN (SELECT    EMPLOYEE_ID  -- Select data from table
                 || FIRST_NAME
                 || LAST_NAME
                 || JOB
                 || HIRE_DATE
                 || SALARY
                 || DEPARTMENT_ID
                    AS Alias
            FROM EMPLOYEES )
      LOOP
  v_text := i."Alias";
         
      /*   HTP.p ('' || replace(v_text,'&amp;','&') || '');*/
     HTP.p (''|| replace (replace (UPPER(v_text), chr (13), ''), chr (10), ' ')|| '');
       
      END LOOP;

      HTP.p ('</span>');

END;



3.Copy Pest the JavaScript code into Page >> Function and Global Variable Declaration
==========

(function () {
    var textFile = null,
    makeTextFile = function (text) {
    var data = new Blob([text], {type: 'text/plain'});
    if (textFile !== null) {
    window.URL.revokeObjectURL(textFile);}
    textFile = window.URL.createObjectURL(data);
    return textFile;};
    var create = document.getElementById('create'),
    textbox = document.getElementById('TEST_ID'); 

    var link = document.getElementById('downloadlink');
    link.href =          makeTextFile(textbox.innerHTML.replace(/&amp;/g,"&").trim());
    link.style.display = 'block';

})();




Click On Download