Code of trigger not working

carox's Avatar, Join Date: Nov 2007
Newbie Member
Can anyone help me in finding whay the below code is not working. It says "invalid character"
It is a trigger on table teacher that restricts from updating and deleting of the records on weekends.
Code:
CREATE OR REPLACE TRIGGER NOT_WORKING _HOUR 
BEFORE INSERT OR DELETE OR UPDATE ON TEACHER 

BEGIN 
IF (TO_CHAR(SYSDATE,'DY') IN ('SAT','SUN')) THEN 
DBMS_OUTPUT.PUT_LINE('SORRY! YOU CANNOT UPDATE OR DELETE ON WEEKENDS'); 
END IF; 
END
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Your name of the trigger contains a space.