包头声明游标,存储过程
type UPDATE_ID is ref cursor;
PROCEDURE PRO_UPDATE_ID(
User_Name_v IN varchar2
);
存储过程体:
PROCEDURE PRO_UPDATE_ID(
User_Name_v IN varchar2
)
IS
CURSOR UPDATE_ID IS SELECT * FROM APP022.TEST ;
BEGIN
FOR v_sal IN UPDATE_ID
LOOP
UPDATE APP022.TEST
SET ID= TEST_ID.nextval
WHERE ID=v_sal.ID;
END LOOP;
END PRO_UPDATE_ID;