Unanswered: Creating trigger but having a "Warning: Trigger created with compilation errors."
I've been working on several triggers and always have this msg :
"Warning: Trigger created with compilation errors."
I dunno why, here's one of the triggers that gives that msg :
CREATE OR REPLACE TRIGGER CityExists
BEFORE INSERT OR UPDATE ON Player
FOR EACH ROW
WHEN (NOT EXISTS( SELECT idTeam FROM Team WHERE Team.idTeam = NEW.idTeam)) THEN
signal sqlstate '45000'
set message_text = 'Attempt to insert a player with an non-existing city.';
I don't know if i'm missing something here, a semicolon, a space or tab ?