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 ?