Don't assume that the mechanism works the same as sql server.(It doesn't)
You will be in for a big surprise.
Read the Oracle documentation carefully or get Thomas Kyte's book One on One
Expert Oracle.
Jim
"Massis Isagholian" <massis_at_socal.rr.com> wrote in message
news:1G6q7.25941$bG6.6325133_at_typhoon.we.rr.com...
> 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 Thu Sep 20 2001 - 00:36:26 CDT
