Re: improbable ora-01722

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 22 Aug 2007 15:02:28 +0200
Message-ID: <46cc33e6$0$230$e4fe514c@news.xs4all.nl>

"steph" <stephan0h_at_yahoo.de> schreef in bericht news:1187782120.127656.214050_at_r23g2000prd.googlegroups.com...
> 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
>

10.1.0.5 shows same behaviour: ORA-01722: Invalid number....

Shakespeare Received on Wed Aug 22 2007 - 08:02:28 CDT