create or replace trigger Exception_trigger
after insert or update on Drug
for each row
declare V_ERROR exception;
begin
if :new.quantity < 10
then raise V_ERROR;
end if;
exception`
when V_ERROR then
dbms_output.put_line('drug quantity is less than 10');
end;
Aucun commentaire:
Enregistrer un commentaire