is invalid and failed re-validation

[johnnygomez]

ese trigger ya lo arregle, era una estupidez, tenia mal uno de los nombres de las tablas y en el if no va beggin, ahora tengo tambien error en este trigger

CREATE OR REPLACE TRIGGER T1_STATEMENT
AFTER INSERT OR UPDATE OR DELETE ON PSEMILLA
DECLARE Y NUMBER; X NUMBER;
CURSOR C IS SELECT ID_SEMILLA FROM TMP_PSEMILLA;
BEGIN
OPEN C; FETCH C INTO Y;
WHILE C%found LOOP
SELECT COUNT(*) INTO X FROM PSEMILLA WHERE ID_SEMILLA=Y AND CANCELADO='N';
IF (X = 0) THEN --SI NO HAY PRESTAMOS NO CANCELADOS PARA LA SEMILLA
UPDATE SEMILLA SET EN_PRESTAMO ='N' WHERE ID_SEMILLA = Y;
ELSE --SI HAY ALGUN PRESTAMO NO CANCELADO PARA LA SEMILLA
UPDATE SEMILLA SET EN_PRESTAMO ='S' WHERE ID_SEMILLA = Y;
END IF;
FETCH C INTO Y
END LOOP;
DELETE FROM TMP_PSEMILLA;
CLOSE C;
END;


que me tira el siguiente error;

LINE/COL ERROR
13/4 PLS-00103: Encountered the symbol "END" when expecting one of the following: . ( , % ; limit The symbol ";" was substituted fo r "END" to continue.

este tp me tiene las podrido ya