Is it possible redirect to another page using process? I dont want to use branch.
I have a process and a branch currently. Both onload - before header and condition type - User is Authenticated. When I do this, I see that process is not getting executed , it directly redirects.
I want to redirect after the process is execute.
What is your apex version?
What does the process do?
What is the sequence of both process and branch?
Have you checked the page events?
Here is Apex info:
Application Express 4.1.0.00.32
DB details - Oracle Database 11g Enterprise Edition Release 18.104.22.168.0
Web server architecture - APEX listener
Browser(s) and version(s) used - Chrome version 24/ Firefox version 3.6 and version 18
In the Process I am searching for a value in Table1 if it doesnt exist, I insert that value into table and also retrieve the id of the newly added value. This id is used in second page that it is redirected to.
I have given the sequence number for process as 10 and branch as 20.
I checked the process events, redirect is first and then process even thought sequence number is 10 and 20. how do I make it execute process first?
Create a branch with On load before header and branch type as Branch to PL/SQL Procedure
Remove the page process and add that logic into the branch PL/SQL procedure/plsql block.
Use owa_util.redirect_url('f?p=&APP_ID.:10:&APP_SESSION.'); to redirect after your logic is executed
Edited by: VC on Feb 22, 2013 10:23 AM