Results 1 to 3 of 3

Thread: Trigger problem

  1. 11-10-2005, 02:37 PM #1
    182
    182 is offline Registered User
    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.
    Reply With Quote Reply With Quote
  2. 11-10-2005, 04:14 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    It could be case issue, try upper case

    IF TO_CHAR(sysdate, 'dy') ='MON'
    OR TO_CHAR(sysdate, 'dy')='TUE' THEN
    Reply With Quote Reply With Quote
  3. 11-10-2005, 04:56 PM #3
    182
    182 is offline Registered User
    Join Date
    Dec 2004
    Posts
    37
    Thanks for the advice.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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