Hello,
i have this process that calls another procedure (PL/SQL code) after page submission
DECLARE
EXECUTION_ID integer;
AUTH_USER_NAME VARCHAR2(100);
BEGIN
select user_name INTO AUTH_USER_NAME from APEX_WORKSPACE_APEX_USERS where user_name = :APP_USER;
insert into test values (1, 'test_APP_USER:' || :APP_USER);
BEGIN_EXECUTION(:P2_SELECT_COLUMNS,AUTH_USER_NAME,EXECUTION_ID);
apex_util.set_session_state('P2_EXECUTION_ID',EXECUTION_ID );
END;
the procedure "BEGIN_EXECUTION" calls another 4 procedures inside it, so it takes almost one minute to complete the process. (the procedures work fine and i have no problems with them)
BUT, what i want to do is to make a status bar or a progress bar that tells the users that everything is working (so that the user wont assume that it is not working ) and (for example) 10% is completed .. 20% is completed ... etc OR something that tells the users : STARTING ... COMPILING ... FINISHED ... etc
long story short, an indicator that tells the user that his request is in progress.
how can i do that ??
thank you and have a nice day.