In your workspace on https://oracleapex.com/ords/ (24.2.11 when I tried) create a new APEX application, named "Test Application Comments".
Click "Edit Application Definition", then "Edit Application Comment".
Populate the "Comments" field, with all the possible characters up to the text box limit. For example I copied the "Test" word multiple times, composing a "TestTestTest...TestTes" string 32768 chars long.
Press "Apply Changes" and export the application into an "f<nnn>.sql" script.
If you try to import that script, you get "Error uploading imported file. ORA-06502: PL/SQL: numeric or value error: character to number conversion error".
Inspecting the "f<nnn>.sql" script, I find the wwv_imp_workspace.create_flow API is invoked with p_documentation_banner parameter composed by concatenation of 131 "TestTestTest..." strings each 250 characters long plus a final "stTestTestTestTes" one, which corresponds to 131*250+18=32768 total chars.
I was able to import the script only after reducing that concatenation to 27 strings 250 each, plus a 204 one, total 6954 char.
I see two issues here:
- The scripts exported from the backend are supposed to be importable as well.
- Application Comments are stored in the Banner field of APEX_240200.WWV_Flow_Banner table, which is CLOB, so they should not be limited to 32768 chars in the App Builder.