How to redirect a certain group login in to another page apex oracle
1010628May 23 2013 — edited May 23 2013so I'm kind of new to apex and If I had a log in page and a certain user logs in that belongs to a certain group... say customers? Well if they log in , it would redirect them to a customer application.. and this is what I'm currently trying to achieve but it doesn't work
This is my code, can you tell me why it doesn't work and a solution to it?
DECLARE
VAL BOOLEAN;
BEGIN
IF
VAL := APEX_UTIL.CURRENT_USER_IN_GROUP(p_group_name=> 'Customer')
RETURN TRUE
THEN
htp.init;
owa_util.redirect_url('f?p=&Custlogin.:1:&APP_SESSION.');
apex_application.stop_apex_engine;
END IF
END;