Hi Tom,

Thanks for the answer. I have a package with some global collection variable is available. I thought of writing an application level process to populate collection in the package which will be triggered after the authentication. But when i checked that collection count in my page, it is showing as zero. Why it is showing like that ?? But If i Select the processing point as on load(before header), the count is showing correctly. The global variables in the package should be persisted across the session rt??

Hi Tom,

In my Oracle apex application, I have created an application level Process and the name of the process is sample_apex_utility which package and this package will populate an array after the authentication is finished. The structure is given below.
create or replace PACKAGE sample_apex_utility AS
TYPE t_apex_utility_tab_type IS TABLE OF varchar2(100) INDEX BY varchar2(50);
t_apex_utility_tab t_apex_utility_tab_type;
END;

The intension of this package is to store my parameter key and values in the associative array defined in this package
So that I can make use of this parameter key values thought the application in different pages(same seesion). I have read the parameter control values from the table and populated this package array after the authentication is finished.

But I have cheked the value in different pages in the same application, the array has no values. What I understood is whithin an apex session, once we set the package variables, the same values will be accessible in all pages in the same session(same application). So I have set the value after the authentication. But the values is not pestied in other pages in the same session. I checked the array count, it is showing as 0. Could you please suggest why it is happening.

Thanks you so much tom. Awsome reply... Really informative. I got the concept clearly.