Oracle Apex Set values before moving to another page, Items are all null

Question

I am trying to do the following:

Anonymous user with a unique key enters a code and clicks 'Start Survey'
The button needs to call a plsql process to populate some hidden page items.
Once the values are set branch to the survey page which will use the hidden items for filtering results.

The Problem

No matter what I have tried so far the items set by the process are null when I get to the next page. I assume this is because it did not submit. The way I have it at the moment is:

Button navigates to the next page
New process set to when the button is pressed sets the values of the page items.

By the time it gets to the next page they are blank again.

I could set the button to submit and do the branch in the processing but I think the submit would happen before the values are set. I find it confusing what order these things happen in.

Can I please get help with making this work, and is there a good article on understanding this area better?

here is the code from the process that puts the values in:

Begin

select id into :P1_pat_id 
from lic_paticipent
where unique_id = :P1_unique_code;

select sur_id into :P1_sur_id 
from lic_paticipent
where unique_id = :P1_unique_code;

select id into :P1_first_res_id
  from lic_result r
  where r.pat_id = :P1_pat_id
  and   r.sur_id = :P1_sur_id
  and   r.qop_id is null
  and   rownum = 1;

End;

Thanks in advance for your help.

can you post the process that is populating the hidden page items?just want to make sure that you are populating the right page items. if you are populating page items of another page, then that is whats wrong with your code. — brenners1302
I have added it to the question above, the process populated three items for page 1 and the process is on page 1. — AndrewT
Just add it to the where clause ie where ID = :P1_first_res_id — AndrewT

AndrewT AndrewT · Accepted Answer · 2016-05-05T02:57:55

OK I solved it and it is my playing around with another issue that cased it. I had set the hidden fields to "Always replacing" instead of "Only when null" so the plsql process updated the session but not the item so when I did a submit the null item replaced what the plsql process had set. I had expected that when the session was updated it would update the item also. I worked it out by making the hidden field visible and could see it was blank but had a value when I checked the session state.

Oracle Apex Set values before moving to another page, Items are all null

2 Answers