Re: problem with a trigger

 > Well, so Oracle must have a setting somewhere to make sunday=7, but
| > I'm just a developer, I'm not aware of such setting. In my DB
| > (8.1.7.4.0), today (friday) is 6, saturday is 7 and sunday is 1:
| >

unsolicited career advise never say 'I'm just a developer...' as an excuse for not knowing how something in the database works -- especially something that will cause your code to fail

| I didn't call you a liar :)
| at school they have also oracle 8.0
| and there also sunday = 1 like you said.
| I think it depends on which db you use.
| I'm using 9.0, it's just my opinion, I don't exactly know why..
| but I still haven't got any help with my trigger.
| Frank? Tiago?
| can't you help me out on this?
|

NLS_TERRITORY [Quoted] since this can be reset for at the session level or by the dba , you can never assume that your code will work unless you know what the NLS settings are, and how they affect your code.

see me other post on how to handle this

• mcs