In short,
I want to close another user's forms who has already open a form session, from current user's form session. For that
| FORMS_DDL('ALTER SYSTEM KILL SESSION '''||R_C_SESSION.SID||','||R_C_SESSION.SERIAL||''' IMMEDIATE '); |
|
Its only kill the session of the user but form session is enable and giving some error messages if he try to do something.
If there is a user viewing the particular record, and another user try to enter I pop up a message for current user to kill the previous user.And I the previous user session killed by following DDL
| FORMS_DDL('ALTER SYSTEM KILL SESSION '''||R_C_SESSION.SID||','||R_C_SESSION.SERIAL||''' IMMEDIATE '); |
But this is not killing the previous user session unless the previous user do something in his session, and giving to previous user that your are logged out. For me I require as soon as second user kill the session the previous user session has to be killed without his knowledge.
Please guide me.
Thanks in advance