oracle - Posting a table via hidden input runs into varchar2 and htp.p size limit -

I have tables that can be sorted and filtered on the browser, via jquery plugins. There is also a download button that copies the modified content of the table with the hidden input and presents it in the Oracle, which then prints the value of the input using an HP header with an Excel header. It works fine for tables of a certain size, I am asked to open the file in Excel I

On the big table though I get this Mod_plsql: /pls/braganza/play.download_filtered HTTP -400 Price is very long Length is 531 9 6. The upper limit is 32512

Any way to dismiss this limitation?

Actually, buffer your input fields in many areas. Pseudo code:

• Assign table to hidden input
• If
  • [hidden input]. Length & lt; 32k
  • Submit
  • Hidden in the input # 1 = [hidden input]. Substrings (1, 32a)
  • hidden Input # 2 = [hidden input]. Substrings (32K + 1, 64A)
  • Hidden input # 3 = [hidden input]. Substrings (64k + 1, 96a)
  • Submit

    This is an identical / identical method in APEX for large (32k +) clips feeds.

    I also switch to the flexible parameter passing the nature of mod_plsql access, it will save you a lot of time / trouble for this particular problem if you are not already using it.