Re: DBMS_SQL: Can I update a DBMS_SQL cursor record?

There's a function in dbms_sql package to return the rowid of the current row.
function last_row_id return rowid;

• Rowid of the last processed row.

--
- Dan Clamage
http://www.telerama.com/~dclamage
If you haven't crashed the Server,
you haven't been trying hard enough.

cbarron2_at_my-dejanews.com wrote in article <6ol41f$lgq$1_at_nnrp1.dejanews.com>...
> Is it possible to update the current record fetched by a DBMS_SQL cursor?
I'm
> looking for a solution similar to the UPDATE...WHERE CURRENT OF feature
of
> regular PL/SQL cursors.
>
> Thanks,
> Chris Barron
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Thu Jul 16 1998 - 23:39:31 CDT