08-Exception-Catch.txt

declare
  
 V_SALESPRICE number;
 V_PRODUCTID number:=123;

begin

  select SALESPRICE into V_SALESPRICE from Product where PRODUCTID=V_PRODUCTID ;

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


  exception
    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;