AJAX result length > 32000
558802Sep 11 2007 — edited Nov 14 2007Hi all,
I have a question regarding AJAX result length in APEX. I have a javascript function calling an application process with AJAX. The application process returns a string and the string is displayed on the the screen with javascript :
function myJSfunction() {
var ajaxRequest = new htmldb_Get(null,&APP_ID.,'APPLICATION_PROCESS=myProcess',0);
ajaxRequest.add('PARAM_1',someParamHere);
ajaxResult = ajaxRequest.get();
if(ajaxResult) {
document.getElementById("mydiv").innerHTML = ajaxResult;
}
ajaxRequest = null;
}
The AJAX result is a VARCHAR2(32000), which is the max size of a VARCHAR in PL/SQL. My problem is that sometimes this result is bigger than that. So how can I exchange results bigger that 32000 chars, between my process and javascript ?
Your suggestions and comments are really appreciated, as its a recurrent problem in my application ...
Thanks,
Othman.