Updating a cursor mary lynn rajskub dating rush limbaugh
In the example below, I'm trying to update the field Current POs in temporary table #t1, based upon a query that uses to reference this, but it doesn't work.
I have also attempted to use an update statement against cur PO, also unsuccessfully.
WHERE CURRENT OF cursor, will allow the update to happen using cursor state, instead of looking up the correct row, as with, update ... Product_ID' could not be bound." Obviously I'm using the wrong syntax.But if you look closely, most of the time we use cursors to iterate through a row collection and update the same table.In these type of situations, it is ideal to use a Update Cursor, than using the default read only one.In earlier versions of Oracle, this error was ignored which lead to occasionally incorrect results.2) Do you need to update the table on a row-by-row basis?