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 causes the form not to respond. What's the issue?? .Can anyone tell?.
Am I doing it the right way?.(Or how can I use session in my application). It does not call the login screen
after expiration. WIN_API_SESSION is 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 causes the form not to respond. What's the issue?? .Can anyone tell?.
Am I doing it the right way?.(Or how can I use session in my application). It does not call the login screen
after expiration. WIN_API_SESSION is not working.
eveloper forum