Variables scoped to the session (connection)?

From: Tom Green <tom.green_at_carvertechnologies.com>
Date: 28 Jun 2004 12:41:01 -0700
Message-ID: <23d24685.0406281141.5206ffaf@posting.google.com>

Is there a way to create a variable at the session (connection) level in Oracle? I could do the equivalent in SQL server by creating a temporary table and filling some field with a value. I'm looking for a kind of SET command. But I have to do this with Oracle.

I want to store the current (application-defined) user ID in it. I need to write a deletion trigger to log deletions, and the trigger needs to know who deleted the record. My idea was that, after my VFP application opened the connection, it would set some variable (e.g. USER), and that the trigger could then read its value.

If that is not possible, I am looking for suggestions.

TIA. Tom. Received on Mon Jun 28 2004 - 14:41:01 CDT