Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Check constraint question...

Check constraint question...

From: CJ Butcher <cj_at_cjbutcher.com>
Date: Thu, 25 Apr 2002 03:45:48 GMT
Message-ID: <LZKx8.1192$hr4.426365102@newssvr13.news.prodigy.com>


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

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 Wed Apr 24 2002 - 22:45:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US