An updatable, or positioned, cursor is a cursor defined by the application for a query that can also used to update the results rows.
A cursor is updatable if there is at least one positioned DELETE or positioned UPDATE that references it inside the FOR loop.
You can use updatable and read-only cursors in stored procedures with the following exceptions:
Updatable Cursors | Read-Only Cursors |
---|---|
Allowed only in ANSI transaction mode. | Allowed in ANSI and Teradata transaction modes. |
Positioned DELETE or UPDATE statements can be used. The table name in these statements must be the same as that used in the cursor specification.
|
Positioned DELETE or UPDATE statements cannot be used. |