Re: updating current row of cursor resultset in OCI

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Mon, 8 Sep 2003 23:54:37 +0300
Message-ID: <3f5cec8f$1_1@news.estpak.ee>

> I saw that this question was posed before on many occasions, and there
> were basically 2 types of response (1) No response (2) Use rowid as
> part of the "SELECT ... FOR UPDATE". This second option, although
> seems to work, also appears to be a hack. It looks like a hack because

In addition to others' posts I'd say that using rowids is not a hack *as long as you're locking the rows* - which usually means select for update. That way these row's can't disappear nor relocate somehow.

Tanel. Received on Mon Sep 08 2003 - 15:54:37 CDT