samedi 23 octobre 2021

what is the problem why if condition not working here?

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