Re: Oracle9: Can I create a variable for each session?

"Andreas Mosmann" <keineemails_at_gmx.de> wrote in message news:1123679987.6_at_user.newsoffice.de...
> Hi,
>
> hope I can explain it.
> Is there a way an application can store any variable in a session so
> that any function/trigger can use this?
>
> f.e.
> ActualUser:=(a number) [1]
>
> crete trigger ...
> :new.id:=ActualUser;
> end;--trigger
>
> Important is, that this variable must be created for each session.
>
> The only way I can imagine is to create a table where every session
> inserts a row with session-id and user-id and trigger has to look into
> v$session and this table, preconditioned there is a possibility for the
> trigger to get to know which session called it.
>
> Thanks
>
> Andreas
>
> [1] User in that case isn't an Oracle-User. There are some users that
> share 1 oracle- user
>
> --
> wenn email, dann AndreasMosmann <bei> web <punkt> de

A package would do just fine.

You don't need a laser drill to tap a hole.

-- 

Andreas Sheriff
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer
----
"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding, if you don't eat your meat?"

DO NOT REPLY TO THIS EMAIL
Reply only to the group.