06-CursorImplicit.txt

create or replace procedure PRODUCT_UPDATE_CURSOR_IMPLICIT(P_CATEGORYID number,P_PERCENT number)
  
is
     V_AFFECTED number;

begin

 
  update PRODUCT
  set SALESPRICE=SALESPRICE+ SALESPRICE*P_PERCENT/100
  where CATEGORYID=P_CATEGORYID;

  if sql%found then
    V_AFFECTED:=sql%rowcount;
    dbms_output.put_line('Dize say�s�: ' || V_AFFECTED );
  elsif sql%notfound then
    dbms_output.put_line('Hi� dize bulunamad�');
  end if;


end;



begin
	
	PRODUCT_UPDATE_CURSOR_IMPLICIT(2,15);
  
end;