Re: How to identify in a single way the value of a session

in fact, my problem is:
User A insert many records in table A (Commit is necessary, it's a particular execution) !! when user stop application all data are deleted. (ok)
User A insert many records in table A but session abort data are not deleted (its a problem because we can't normally delete this records) => I want to scan in table A all records and look for the value of the stored session. if session doesn't exists i can delete record ect ...

regards
Denis

"Knut Talman" <knut.talman_at_mytoys.de> wrote in message news:3CC6731B.6020209_at_mytoys.de...
> Epicentre Team A ANNECY wrote:
>
> > Do you think this that the column "VALUE" of v$mystat is ok for use it
on a
> > primary key ?
> > Why not use "SADDR" of v$session ?
>
>
> Of course it is NOT ok. Neither VALUE nor SADDR should be used. You want a
> _primary_ key, not just a key. Primary means also unique but the data you
want
> to use is not unique when you insert more than one record per session.
> Why don't you use a sequence?
>
> Regards,
>
> Knut
>
>
>
>
Received on Wed Apr 24 2002 - 04:20:22 CDT