Re: newbie row locking question

Hi Jim.

Oracle will handle it, just put row_locking=ALWAYS in your init.ora file.

Best regards.

Jim Haran <jim_haran_at_datasoft-inc.comREMOVE_THIS> wrote in article <362C92D7.F0BD2ACC_at_datasoft-inc.comREMOVE_THIS>...
> Hello all,
> As a recent newcomer to the Oracle world, there are a few questions
> I have. I have not come across documentation that covers row locking. In
> the old world (xBase), I would lock a record as soon as the user
> accessed it. As such, if another user attempted to edit the same
> receord, the lock would be detected and a dirty read at best would be
> allowed.
> Do I need to explicitly lock rows in my apps? If not how does one
> control possible concurrent updates to the same row? I'm sure this is
> covered somewhere in the documentation but I have'nt found it. Thanks in
> advance for any help.
>
> Jim
>
>
Received on Thu Oct 22 1998 - 12:45:37 CDT