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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to set a global variable (cannot get page item value in process)

Pavel_pAug 7 2011 — edited Aug 7 2011
Hi all,
please, could anybody help me with the following problem?
I want to use a global variable which is set on the login page as a value picked from the listbox (page item P103_SELECT_LIST). So I created application level item F103_MY_GLOBAL_VAR and then on the login page I created a process. Body of the process is:

begin
:F103_MY_GLOBAL_VAR := :P103_SELECT_LIST;
end;

I do not know why P103_SELECT_LIST is still null (in debug window I see that P103_SELECT_LIST has some not null value (0.06300 0.00000 ...Session State: Saved Item "P103_SELECT_LIST" New Value="1"). When I change the process body and I assign a static value to F103_MY_ITEM (the process looks like this)

begin
:F103_MY_GLOBAL_VAR := 1;
end;

everything works perfectly.
I'm getting mad about it and any help will be highly appreciated:-).
Thanks in advance,
Pavel

Edited by: user6373469 on 7.8.2011 4:38
This post has been answered by Arie Geller on Aug 7 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 4 2011
Added on Aug 7 2011
4 comments
5,344 views