Re: Variables scoped to the session (connection)?

On 28 Jun 2004 12:41:01 -0700, tom.green_at_carvertechnologies.com (Tom Green) wrote:

>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.

 Package variables and application contexts both sound like they would fit the bill.

--
Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
http://www.andyh.co.uk         / http://www.andyhsoftware.co.uk/space