Home » Developer & Programmer » Forms » How to redirect to login screen after inactive sessions (Oracle Developer Forms 6i(6.0.8.11.3))
How to redirect to login screen after inactive sessions [message #389191] Fri, 27 February 2009 09:51 Go to next message
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

Re: How to redirect to login screen after inactive sessions [message #389890 is a reply to message #389191] Wed, 04 March 2009 00:05 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What code do you have in 'logon_screen'?

The usage notes say "If you call certain built-ins from within one of the Logout triggers, the results are undefined. For example, the COPY built-in cannot be called from a Pre-Logout trigger because Pre-Logout fires after the Leave the Form event. Because the form is no longer accessible at this point, the COPY operation is not possible."

David
Re: How to redirect to login screen after inactive sessions [message #390984 is a reply to message #389890] Tue, 10 March 2009 09:59 Go to previous messageGo to next message
betcyt
Messages: 2
Registered: February 2009
Junior Member
I used the LOGON_SCREEN built-in to
simulate the default login screen. Could you please help me how to accomplish this task?
Re: How to redirect to login screen after inactive sessions [message #394199 is a reply to message #390984] Thu, 26 March 2009 00:55 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

Did you answer my question?

David
Previous Topic: difference forms/reports
Next Topic: Problem to open a form
Goto Forum:
  


Current Time: Thu Dec 08 00:40:19 CST 2016

Total time taken to generate the page: 0.09953 seconds