Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AJAX result length > 32000

558802Sep 11 2007 — edited Nov 14 2007
Hi 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2007
Added on Sep 11 2007
15 comments
1,656 views