• Home
• it.cnr.si.sigla
• sigla-backend
• 6.6.4
• source code
• bu_pdg_variazione.trg

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

expsigladb.Trigger.bu_pdg_variazione.trg Maven / Gradle / Ivy

CREATE OR REPLACE TRIGGER BU_PDG_VARIAZIONE
  BEFORE UPDATE OF STATO
  ON PDG_VARIAZIONE
  FOR EACH ROW
BEGIN

 IF :OLD.STATO = 'APF' AND :NEW.STATO = 'ANN' THEN
  IBMERR001.RAISE_ERR_GENERICO('La variazione risulta approvata formalmente, annullamento impossibile.');
 END IF;
END;
/