Is there any way to define custom variables per session scope?
In oracle, we do this using package variables.
Basically when a user logs into our application, it generates one-time
session information that we want to make available to all the procedures
and triggers, without passing it directly (even if that were possible
with
triggers).
Is inserting/selecting data from temporary tables the only way to
accomplish this ?