Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forums/oracle-forum/)
-   -   Code of trigger not working (http://www.go4expert.com/forums/code-trigger-t7847/)

carox 15Dec2007 00:42

Code of trigger not working
 
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


shabbir 15Dec2007 12:12

Re: Code of trigger not working
 
Your name of the trigger contains a space.


All times are GMT +5.5. The time now is 11:38.