I'm trying to run the statement below but I continue to get the error messages that the Rowid was not declared and v_trans is used incorrectly. This code the trans_no field with values starting from the maximum trans_novalue.
Can someone please help me debug/rewrite this update code?
CURSOR Upd_trans_no IS
SELECT trans_no,row_id from temp_reimb_control;
V_counter_num pls_integer := 0;
FOR v_trans in Upd_trans_no LOOP
-- update every record with null trans_no values
IF v_trans.trans_no is NULL THEN
-- Increment transaction counter
v_counter_num := v_counter_num + 1;
SET trans_no = (select max(trans_no) + v_counter_num from temp_reimb_control)
WHERE row_id = v_trans.ROW_ID;
you have a previous thread on development forum, the appropriate one so I am closing this thread
Click Here to Expand Forum to Full Width