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!

ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Oracle apex 18.1

Dijomon VargheseNov 13 2018 — edited Nov 13 2018

Hi All,

I am getting the below error in Interactive Report of oracle apex 18.1,it has around 3 lacs records when i click on that REFRESH button i am refreshing the region every 30 seconds initially the rows per page was 50 and it worked well when i change the rows per page to ALL its throwing the below error.Facing the same issue in Interactive Grid too.

to refresh the page i am using this piece of code

$('#REFRESH').click(function(){

setInterval(function(){ $('#EXEC\_LOG').trigger('apexrefresh'); }, 3000);

});

regards

Dijomon

Added on Nov 13 2018

#apex-discussions, #interactive-grid

10 comments

484 views