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