improbable ora-01722

This bugged me a bit today:

create table steptest(a number);

alter table steptest add (constraint steptest_check1 check (a in ('J','N')));

insert into steptest values (1);

==>ORA-01722
Of course the check constraint makes no sense on this column ... but Oracle (9i) does not mind. The resulting error message led me in completely wrong directions. Bug or feature?

stephan Received on Wed Aug 22 2007 - 06:28:40 CDT