I'm attempting for the first time to put together a PL/SQL script to sequentially update a field within a table... I'm working with the following:
/* Output variables to hold the result of the query: */
i NUMBER(6) := 90000;
/* Cursor declaration: */
CURSOR GM_BOOK_Cursor IS
SELECT C12_BOOK_ZKEY, C11_BOOK_REFRESH, C14_BOOK_UTIL1
UPDATE ZGASMASTER_BOOK_MERGE SET C12_BOOK_ZKEY = i WHERE CURRENT OF GM_BOOK_Cursor;
i := i + 1;
/* Free cursor used by the query. */
When I attempt to run this I get an ORA-01410 error. In essence I'm trying to update a set of rows with an updated counter value (i) where each row will increment by i + 1... Perhaps I'm going down the wrong path altogether???
Thanks in advance.