Home » SQL & PL/SQL » SQL & PL/SQL » Session out after 30 min.
Session out after 30 min. [message #230635] Thu, 12 April 2007 06:56 Go to next message
rahul.priyadarshy
Messages: 28
Registered: December 2005
Junior Member
Hi,

We have a web application which is being developed using plsql, plsql web toolkit (htp.p) & javascripts. User wants us to get the session out after 30 min. Could you please let us know if we can do this using plsql.

Thanks





Re: Session out after 30 min. [message #230639 is a reply to message #230635] Thu, 12 April 2007 07:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
maybe profile.idle_time or profile.connect_time.

Regards
Michel
Re: Session out after 30 min. [message #230666 is a reply to message #230635] Thu, 12 April 2007 09:44 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Presumably you are maintaining some sort of pseudo state in the database, (I'm assuming that this is a stateless application).
If so, just record the time when a user does something, make a check on the time since they last did something one of the first things that your app does - if the time difference is > 30 minutes, then tell them their session has timed out.
Previous Topic: Query
Next Topic: Materialized View ORGANIZATION
Goto Forum:
  


Current Time: Fri Dec 02 21:07:00 CST 2016

Total time taken to generate the page: 0.27417 seconds