Oracle9: Can I create a variable for each session?

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