09-Exception-Raise.txt

declare
  
 V_SALESPRICE number;
 V_PRODUCTID number:=9;
 E_PRODUCT_INVALID_SALESPRICE exception;
begin

  select SALESPRICE into V_SALESPRICE from Product where PRODUCTID=V_PRODUCTID ;

  if V_SALESPRICE<100 then
    
	raise E_PRODUCT_INVALID_SALESPRICE;

  else

     dbms_output.put_line('Sat�� ederi: ' || to_char(V_SALESPRICE));

  end if;

  
  exception
    when E_PRODUCT_INVALID_SALESPRICE then 
        dbms_output.put_line('Sat�� ederi k���k: ' || to_char(V_SALESPRICE));
    when no_data_found then 
        dbms_output.put_line('�yle bir �r�n yok: ' || to_char(V_PRODUCTID));
    when others then
        dbms_output.put_line('Bir yanl��l�k oldu: '||to_char(V_PRODUCTID));

end;