07-Trigger.txt

create or replace trigger PRODUCT_SALECEPRICE_VALID
before
insert or update on PRODUCT
for each row
-- when :new.SALESPRICE <= 0 and  new.SALESPRICE < old.SALESPRICE  
begin
    dbms_output.put_line('�r�n ekleme/g�ncelleme..');
    if :new.SALESPRICE <= 0 then
          RAISE_APPLICATION_ERROR(-20101,'Sat�� ederi art� olmal�');
    end if;
	if :new.SALESPRICE < :old.SALESPRICE then
          RAISE_APPLICATION_ERROR(-20102,'Sat�� ederini indiremezsiniz');
    end if;

end;
/
alter trigger  PRODUCT_SALECEPRICE_VALID ENABLE;


insert into PRODUCT (PRODUCTNAME, SALESPRICE) values ('Frit�z',120.0)

Inserting or updating product..

1 row(s) inserted.

0.00 seconds


insert into PRODUCT (PRODUCTNAME, SALESPRICE) values ('Frit�z',-120.0)

ORA-20101: Sat�� ederi art� olmal�
ORA-06512: at "OURUSER.PRODUCT_SALECEPRICE_VALID", line 4
ORA-04088: error during execution of trigger 'OURUSER.PRODUCT_SALECEPRICE_VALID'


update PRODUCT set SALESPRICE=110.0 where PRODUCTID=8


ORA-20102: Sat�� ederini indiremezsiniz
ORA-06512: at "OURUSER.PRODUCT_SALECEPRICE_VALID", line 7
ORA-04088: error during execution of trigger 'OURUSER.PRODUCT_SALECEPRICE_VALID'