-
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
-
How many places are you going to post this question?
-
very sorry, just looking for a bit of help is all..
Carpe Diem
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|