APEX

Hi!

I am using custom authentication for logging into my application. It uses an internal table for username and password verification. The rest of the authentication is managed by APEX. Here is my login process on the login page:

declare
  v_auth_successful boolean := false;
begin

  v_auth_successful := pck_auth.authenticate(p_username => :P101_USERNAME,
                                             p_password => :P101_PASSWORD);
  
  if v_auth_successful then
    
    wwv_flow_custom_auth_std.post_login(
        P_UNAME       => :P101_USERNAME,
        P_PASSWORD    => :P101_PASSWORD,
        P_SESSION_ID  => v('APP_SESSION'),
        P_FLOW_PAGE   => '&APP_ID.:1'
        );
  
  else
    owa_util.redirect_url('f?p=&APP_ID.:LOGIN:&SESSION.');
  end if;
end;

My problem is that I can't have two simoultaneous active sessions in two browser tabs. When I login into the app in the first tab I can navigate through application fine. But as soon as I open a second tab and log into the application (with new session ID), the first tab is no longer working - I am redirected to the login page. And when I log in again, the second tab is no longer working...etc.

Example can be seen here: [http://apex.oracle.com/pls/otn/f?p=47326:1|http://apex.oracle.com/pls/otn/f?p=47326:1] - just open this link in two tabs and log in (any username/password will do)

Does anybody know how to solve this issue? I believe I am missing something (in my authentication scheme???)


Thank you,
Jure