Untitled

CREATE OR REPLACE TRIGGER SVAS.trg_isl_region_cd
AFTER INSERT OR UPDATE ON issuer_location
FOR EACH ROW
--
DECLARE
dummy NUMBER;
--
CURSOR RI_check IS
SELECT 1
FROM refdata.vew_region p

WHERE  :new.region_cd =
p.reg_code
AND  :new.country_id =
p.reg_country_id;
--
BEGIN
   IF (:new.region_cd IS NOT NULL AND
       :new.country_id IS NOT NULL AND (INSERTING  OR (:new.region_cd != :old.region_cd) OR (:new.country_id != :old.country_id))) THEN
      OPEN RI_check;
      FETCH RI_check INTO dummy;
      IF (RI_check%NOTFOUND) THEN
          CLOSE RI_check;
          RAISE_APPLICATION_ERROR(-20000,'Cannot INSERT or UPDATE issuer_location because refdata.onyx_regions_tbl does not exist.');
      END IF;
      CLOSE RI_check;
   END IF;
END;