1 Reply Latest reply: Sep 16, 2013 2:24 AM by Ahmed Alsaied RSS

    Update Values when logout

    Ahmed Alsaied

      Hi ,

      I want to make DML process when the user logout :-

      i do the following steps :-

      1-I change the url &LOGOUT_URL to another page not the login page like 10  , as wwv_flow_custom_auth_std.logout?p_this_flow=&APP_ID.&p_next_flow_page_sess=&APP_ID.:10

      2- Make tow process in the page

      one (on-load before header) to do dml code like this

      BEGIN
      UPDATE SYS_USERS
      SET ACTION_STATUS = 2
      where upper(:p101_username)  like upper(USER_NAME);
      commit;
      END;
      

      and another process after header

      apex_application.g_unrecoverable_error := true; 
      wwv_flow_custom_auth_std.logout( 
      p_this_flow => :APP_ID, 
      p_next_flow_page_sess => :APP_ID ||':101'
      );
      

       

      to go to the login page

      but the dml code not execute

      and when try to login again i have this error

      Content-type: text/html; charset=UTF-8 Content-type: text/html; charset=UTF-8 Set-Cookie: ORA_WWV_APP_100=-1; HttpOnly Location: /apex/f?p=100:101

       

      I need Help