Re: Session variables and PL/SQL

Ted Knijff wrote:

> 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

Personally I'd alter the default profile and make it impossible to do so.

But if you can't or choose not to ... look at SYSTEM TRIGGERS.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)