Re: SELECT Field1, Field2....Fieldn FROM MyTable FOR UPDATE - Question about concurrency.

Paul Linehan wrote:
>
> Dear Oracle gurus,
>
>
>
> Suppose my app has a statement like the above (or below):
>
>
> SELECT Field1, Field2....Fieldn FROM MyTable FOR UPDATE
>
>
> and I've just issued it. The phone then rings "Honey,
> my waters have just broken, I'm in hospital xxx",
> so I rush out the door, leaving app and everything.
>
>
> Now, my question is, what happens the record(s) that
> I have selected FOR UPDATE and how do I ensure that
> an errant operative (for however good a reason) hasn't
> left the app standing with records locked?
>
>
> TIA.
>
>
> Paul...

You don't unless you have been smart enough to configure your profile to include an IDLE_TIME after which Oracle should kill your connection.

BTW: I hope on your way home and then to the hospital you obeyed each and every traffic law to the letter. <g>

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org