Check constraint question...

From: CJ Butcher <cj_at_cjbutcher.com>
Date: Thu, 25 Apr 2002 03:46:20 GMT
Message-ID: <g_Kx8.1193$3u4.426545303_at_newssvr13.news.prodigy.com>

[Quoted] [Quoted] I'm trying to create a check constaraint and get error stating:

[Quoted] ORA-02436: date or system variable wrongly specified in CHECK constraint

Here is my constraint statement:
ALTER TABLE ACTIVITYTRACKING200205 ADD CONSTRAINT ACTIVITY200205 CHECK (ACTIVITYDATE BETWEEN '01-MAY-02' AND '31-MAY-02'); ACTIVITYDATE is defined as a DATE type. Don't understand why I'm getting the error. I'm using Oracle 9i

Thanks for any help

CJ Received on Thu Apr 25 2002 - 05:46:20 CEST