Re: dynamic cursors (OCI)

There might be other/better answers to this. One way to do this is use ROWID which essentially serves the same purpose as "WHERE CURRENT OF" i.e.
CURSOR c IS

SELECT rowid, a, b from tab for update;
               ^^^^^

Update tab set ..... WHERE rowid = c.rowid;
                                                         ^^^^^^

Anurag

"Massis Isagholian" <massis_at_socal.rr.com> wrote in message news:qMqp7.34$5o3.44010_at_nnrp2.sbc.net...
>
> The FetchRecord function below, uses a server-side cursor to issues a
 SELECT
> statement which retrieve a single row of data. Later on, the application
> needs to update the row and release the concurrency lock by issuing an
> "UPDATE ....... FOR THE CURRENT OF CURSORID" statement.
>
> My problem is that I don't see a way to do this using the OCI interface.
>
> Thanks for you help.
> Massis
>
Received on Mon Sep 17 2001 - 20:13:01 CEST