Re: Oracle OCI question

Thanks for your response, Jim.

In this instance I need the row to remain locked until the cursor is closed. Meanwhile, update statement issued on the cursor's current position should be visible to other applications at the read committed isolation level. Updateable Cursors can be used in MS SQL Server and I'm assuming this mechanism works the same in Oracle.

Massis

"Jim Kennedy" <kennedy-family_at_home.com> wrote in message news:_C5q7.4820$JN.19277_at_news1.sttls1.wa.home.com...
> You can retrieve the rowid in the select and the use it in the update
> statement.(select rowid,....from...; update xxx... where rowid=...) Then
> you don't lock the rows while you look at them.(preventing updates to
those
> rows, most apps. look a lot and don't update everything they look at.)
> Jim
> "Massis Isagholian" <massis_at_socal.rr.com> wrote in message
> news:Yi5q7.25756$bG6.6284541_at_typhoon.we.rr.com...
> > I need some sample C code that uses OCI to create a cursors using the
> "OPEN
> > C1 FOR SELECT ... FOR UPDATE", and later uses the cursor (C1) to update
> the
> > row via the "UPDATE xxxx SET .... WHERE CURRENT OF C1" statement.
> >
> > I've done this using ODBC & MS SQL Server and I'm desperately trying to
> find
> > the equivalent method for the OCI interface.
> >
> > If this isn't the correct newsgroup for this question, I'd appreciate it
> if
> > you'd let me know of a more appropriate newsgroup for this question.
> >
> > Thanks for you help.
> > Massis
> >
> >
> >
> >
> >
>
>
Received on Wed Sep 19 2001 - 14:50:21 CDT