-
Trigger problem
Hey guys, i am trying to create a trigger that won't allow a table to be upddated on monday or tuesday. Can anyone tell me whats wrong with the code I have done for this?
Thanks
IF TO_CHAR(sysdate, 'dy') 'mon'|| 'tue' THEN
RAISE_APPLICATION_ERROR(-2015, 'error');
ENDIF
Last edited by 182; 11-10-2005 at 10:39 PM.
-
It could be case issue, try upper case
IF TO_CHAR(sysdate, 'dy') ='MON'
OR TO_CHAR(sysdate, 'dy')='TUE' THEN
-
Thanks for the advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|