Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle OCI question
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 - 13:38:50 CDT