Results 1 to 3 of 3

Thread: Trigger problem

  1. #1
    Join Date
    Dec 2004
    Posts
    37

    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.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,922
    It could be case issue, try upper case

    IF TO_CHAR(sysdate, 'dy') ='MON'
    OR TO_CHAR(sysdate, 'dy')='TUE' THEN

  3. #3
    Join Date
    Dec 2004
    Posts
    37
    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
  •