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!

Problem with dynamic action - sum

2803469May 4 2017 — edited Sep 1 2017

Posting for one of my developers, using APEX 5.1.1 on Windows

I have been working with 5.1.1 for the last three days. It is very different.

It allows me to display my page that has all the items but it seems that there is still a problem with the number of items trying to sum them.

Here is the issue:

I have a number of items on my page that hold values which I will use to sum a score. Each is calculated with a Dynamic Action.

BEGIN

:P10_Q08E_S  :=  0;

END;

Or

BEGIN

:P10_Q08E_S :=  1;

END;

In the session window I can see that they ALL have a value.

The problem arises when I try to sum those values. Also with a Dynamic Action.

I can only sum the first 32 items. But the limit is not 32 items. It is a very specific. If it were the number in the assignment statement then I should be able to swap out a variable and it still work. NADynamic Action.

  1. i.e.,

A+B+C works

A+B+C+D   does not work

A+B+D does not work

I have  53 score items. I have about 4 times that number of items on the page in total.

I have tired dividing them into two groups, etc. No Dynamic Action.

I have tried giving “D” a higher assignment number. No Dynamic Action.

My basic summation assignment statement is

BEGIN

:P10_GRAND_TOTAL_SCORE :=  :P10_Q01A_S  + :P10_Q01B_S  + :P10_Q01C_S +  etc.;

END;

There is some limit that has been introduced in 5.1.1 and I don’t know what it is.

If you have encountered and know the answer please share.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 29 2017
Added on May 4 2017
14 comments
1,068 views