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!

problem with authentication and owa_util.redirect_url

PavanFeb 3 2014 — edited Feb 6 2014

Hi all,

This is Pavan using apex version 4.2.3,

i am having different type of logins like one is for admin and one is user, depends on user or admin it redirect to particular page, i am using this by custom authentication method in that  i wrote a procedure to redirect to particular page i called this procedure in post authentication the procedure is calling but it's not redirecting its on smae login page only if i am removing its validating the username and password and going to page 1,

i used this procedure

procedure post_auth_4456789976 is

begin

declare

V_PAGE number;

begin

select START_PAGE into V_PAGE from LOGIN_TAB where upper(USER_NAME)=upper(:APP_USER);

owa_util.redirect_url('f?p='||:APP_ID||':'||V_PAGE||':'||:SESSION||'::::::' );

exception

when others then

owa_util.redirect_url('f?p='||:APP_ID||':2:'||:SESSION);

end;

end;

may i know know whats the problem exactly, am i miss anything or am i went wrong, please let me know,

click here for link https://apex.oracle.com/pls/apex/htmldb/f?p=52985:LOGIN_DESKTOP:1110119686316

Thanks in advance,

Pavan

This post has been answered by Christian Neumueller-Oracle on Feb 3 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 6 2014
Added on Feb 3 2014
9 comments
4,221 views