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 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.
