This content has been marked as final. Show 7 replies
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 188.8.131.52.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
thanks for your quick responses.
It executes process but redirect doesnt happen. How do I achieve both?
Check my updated reply above that should work for sure...you will only have one component i.e. branch
This works for me. Is a process (on load - before header):
DECLAREI hope that you find it useful.
l_redirect_url VARCHAR2(1000) := 'f?p=102:1:&SESSION.';
apex_application.g_unrecoverable_error := true; -- > stops all further page processing
Thank you so much.