DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA 1847 - Day must be between 1 & last day of month

  1. #1
    Join Date
    Aug 2000
    Posts
    68

    Question ORA 1847 - Day must be between 1 & last day of month

    Hello

    Im trying to debug a troublesome trigger.

    In my when clause im using this type of logic....

    nvl(old.cust_flag, 'z') <> nvl(new.cust_flag,'z') or
    nvl(old.last_updated_by, 99999) <> nvl(new.last_updated_by,99999) or

    etc

    but im having problems with the date format by this i mean

    nvl(old.last_update,'9999') <> nvl(new.last_update,'9999')

    Table Struct

    cust_flag = VARCHAR150
    last_updated_by = Number 15
    last_update = Date




    The problem is prob the format (ie '9999) above) but im not too sure what to put in when referencing a date???

    I really hope someone can help...

    Thanks in Advacne to anyone who can...
    Carpe Diem

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    How many places are you going to post this question?

  3. #3
    Join Date
    Aug 2000
    Posts
    68
    very sorry, just looking for a bit of help is all..
    Carpe Diem

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    No problem. This forum is for Oracle applications (financials, etc.), so you're not going to get much help about a trigger here. The DBA forum (where you also posted) has a lot more traffic (people reading and answering) than applications.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width