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!

Redirect from PL/SQL in an Application process

Mr NeilMar 24 2015 — edited Mar 24 2015

HI all,

APEX 4.2 - Oracle 10g

I've been reading the forum here and the web. I am failing to get a successful Redirect to page 1 from PL/SQL code in a Application Process.

I see in other forums that developers are getting success with the code below.

Application process runs a PL/SQL Anonymous Block , On Load: Before Header.

The code I'm using has been tested and it fires properly. The issue lies with the actual redirect lines (owa_util.redirect_url).

Begin

If [some clause] = True then

   htp.init;

   owa_util.redirect_url('f?p=&APP_ID.:1:&APP_SESSION.');

   apex_application.stop_apex_engine;

end if;

END;

It looks like the browser (IE 8.0.7601.17514) is trying to open the following...

..../f?p=4000:RUN_PAGE:5795566109287:BRANCH_TO_PAGE_ACCEPT:NO::FB_FLOW_ID,FB_FLOW_PAGE_ID,F4000_P1_FLOW:1284,4,1284

Where as I would expect the following

.../f?p=1284:1:8744058503342::NO:::

Any help appreciated.

Neil.

This post has been answered by Mr Neil on Mar 24 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2015
Added on Mar 24 2015
1 comment
4,889 views