Guest User

Untitled

a guest
Jun 17th, 2017
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE OR REPLACE TRIGGER my_trg BEFORE INSERT OR UPDATE ON Relationships FOR EACH ROW
  2.     DECLARE FUNCTION i_Age
  3.     (id NUMBER) RETURN NUMBER IS
  4.     li_res NUMBER;
  5.     BEGIN
  6.         SELECT p.AGE INTO li_res FROM PERSONS p WHERE p.ID = id;
  7.         RETURN li_res;
  8.     END;
  9.  
  10.     BEGIN
  11.         IF INSERTING OR UPDATING THEN
  12.             IF :NEW.RELATION = 'child' AND i_Age(:NEW.PERSON_ID) >= i_Age(:NEW.RELATIVE_ID) THEN
  13.                 RAISE INVALID_NUMBER;
  14.             END IF;
  15.         END IF;
  16.     END;
Advertisement
Add Comment
Please, Sign In to add comment