Re: Row-locking on "FOR UPDATE" processes - Oracle support pls read.
Date: Tue, 20 Dec 1994 11:13:41 GMT
Message-ID: <James.Lawrence.70.000B3AB3_at_epamail.epa.gov>
In article <bgmccracken.9.003B160B_at_amoco.com> bgmccracken_at_amoco.com (Bill G. McCracken) writes:
>From: bgmccracken_at_amoco.com (Bill G. McCracken)
>Subject: Row-locking on "FOR UPDATE" processes - Oracle support pls read.
>Date: Tue, 13 Dec 1994 00:51:10 Central
>Well, I've called Oracle support 3 different times and posed the same question
>(over the last 2 years) and each time they say it cannot be done...maybe
>there's a new answer for '95?
>Problem is this:
>We have transactional systems (a helpdesk for one app), that use the
>row-locking technique (SELECT .... FOR UPDATE ... NOWAIT) to "hold"
>the record so that another cannot update the current updating record(s), and
>notifies the second user that someone is trying to update the original row(s)
>via the error return code of the locked record. But I cannot tell who
>has the lock on the original record!!
>The second user would like to know who is actually modifying the record
>at that time, in case they need to get at it, or notify them when they are
>'out' of the row(s).
>My solution is to build a "app.LOCK" table, that basically holds all this info,
>and not really use the "FOR UPDATE" process, but check this table first.
>But that's only good for procs, and custom apps.
>Holiday wish: Dear Oracle, please provide us a way to lock records, and know
>who's in them when they're being updated...it's a very simple request!!
>I'm not talking about locking the entire table, which yes, you can then check
>to see who's got the lock, these are high transactional table(s), that multiple
>users have locks on various rows at a time....think of a helpdesk situation.
>P.S. Oracle, how do you handle this on your helpdesk? Or anyone else
>for that matter!!
>-----------------
>Bill G. McCracken
>------------------------------------------------------------------
>Sr. Programmer/Analyst, Information Technology
>Amoco Oil Company, Des Moines, IA 50266
>Internet: bgmccracken_at_amoco.com
>(-: Opinions are not the companies, just my 2 cents worth!! :-)
>------------------------------------------------------------------