Session variables and PL/SQL

From: Ted Knijff <knijff_at_bigfoot.com>
Date: Sat, 19 Jul 2003 17:46:34 GMT
Message-ID: <3f1981f8.5745701@news.t-online.de>

Hi,

how can I best save and retrieve variables based on a session ?

The problem :
-a user logs in multiple times from different clients / from the same client PC (i.e. multiple sessions, same user)
- I want to save the session parameters (login time etc. - as in
v$session view) and access these variables from PL/SQL
- do I have to save his data in a table and retrieve them every time ?

how can I best access the session-id to uniquely identify the session (performance) ?

TIA Ted Knijff
EMail: knijff_at_bigfoot.com Received on Sat Jul 19 2003 - 12:46:34 CDT