Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle OCI question

Re: Oracle OCI question

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Wed, 19 Sep 2001 18:38:50 GMT
Message-ID: <_C5q7.4820$JN.19277@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 - 13:38:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US