04-CursorRow.txt

create or replace procedure PRODUCT_UPDATE_CURSOR_ROW(P_CATEGORYID number,P_PERCENT number)
  
is
  cursor C_PRODUCT is select  * from PRODUCT  where CATEGORYID=P_CATEGORYID for update of SALESPRICE;
  R_PRODUCT PRODUCT%ROWTYPE;

begin

    open C_PRODUCT;
    
    loop
        fetch C_PRODUCT into R_PRODUCT;
        exit when C_PRODUCT%notfound;
        update PRODUCT
        set SALESPRICE=SALESPRICE+ SALESPRICE*P_PERCENT/100
        where current of C_PRODUCT ;
    end loop;

    close C_PRODUCT;

end;​
/

begin
	
	PRODUCT_UPDATE_CURSOR_ROW(2,15);
  
end;