| How to redirect to login screen after inactive sessions [message #389191] |
Fri, 27 February 2009 09:51  |
betcyt
Messages: 2
Registered: February 2009
|
Junior Member |
|
|
How to redirect to login screen in oracle developer forms 6i(6.0.8.11.3), when user session times out.
In my oracle developer forms application, if the user has been idle for more than 30 mins or may be less,
it's logged off automatically and the error coming as FRM - 40655:SQL error forced rollback,clear form
and re-enter transaction.(FRM:40512:ORACLE error:unable to issue SAVEPOINT command ).
This happens since the idle time parameter is set to 30 min. In such situation, I would like to redirect the
user back to the log in screen(instead of exiting from the application). In otherwords the ORACLE system
will request the user's password in order to return to the screen that was previously in use. No data is lost.
For that, I have created a form. Basically I am only using WIN_API_SESSION of that library(D2KWUTIL)
to handle session in my form. But it makes form not to respond. What's the issue?? .Can any one tell?.
Or am I doing it right way.(Or how can I use session in my application). It does not call the login screen
after expiration.WIN_API_SESSION not working.
In my form the when-new-form-instance trigger is below:
declare
lwindow PLS_INTEGER;
ltimer TIMER;
begin
lwindow := get_window_property(FORMS_MDI_WINDOW,WINDOW_HANDLE);
Win_API_Session.Timeout_Start_Timer(lwindow);
ltimer := Create_Timer('TIMEOUT',1000,repeat);
end;
And the when-timer-expired trigger is below:
IF get_application_property(TIMER_NAME) = 'TIMEOUT' THEN
IF WIN_API_SESSION.TIMEOUT_GET_INACTIVE_TIME > 10 THEN
LOGOUT;
LOGON_SCREEN;
END IF;
END IF;
[Updated on: Fri, 27 February 2009 09:59] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
