Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE TRIGGER ejer1
- before INSERT ON tren
- FOR each ROW
- DECLARE
- v_capacidad cochera.capacidad%TYPE;
- v_utilizacion cochera.capacidad%TYPE;
- BEGIN
- SELECT COUNT(*) INTO v_utilizacion FROM tren WHERE cochera = :NEW.cochera;
- SELECT capacidad INTO v_capacidad FROM cochera WHERE codigo = :NEW.cochera;
- IF (v_capacidad > v_utilizacion) THEN
- raise_application_error(-20500,'La cochera no tiene capacidad.');
- END IF;
- EXCEPTION WHEN NO_DATA_FOUND THEN
- raise_application_error (-20501,'La cochera indicada no existe.');
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement