Re: Check constraint question...

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Thu, 25 Apr 2002 14:14:37 +0200
Message-ID: <3CC7F32D.2000008@mytoys.de>

CJ Butcher wrote:

> 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

Crossposting (posting the same question to more than one newsgroup) is bad. Look at my answer in comp.databases.oracle.server.

Regards,

Knut Received on Thu Apr 25 2002 - 07:14:37 CDT