Check constraints - alter order of processing ?

Hi - I've defined a check constraint ...

SQL> ALTER TABLE "WSC_WORKITEM"
  2 ADD CONSTRAINT "CHK_WOR2"
  3 CHECK (WSC_CHANGE_OR_ERROR in ('1','2'))   4 ENABLE
  5 NOVALIDATE;
... and that column, WSC_CHANGE_OR_ERROR looks like ...

WOR_CHANGE_OR_ERROR                       NOT NULL VARCHAR2(1)

... the problem is that if a process attempts an insert into the table
and the contents of that column is, eg, '10', you don't get the check constraint error message returned but instead ...

ORA-01401 : inserted value too large for column ?

... is there any way I can Oracle to report the constraint violation
rather than the ORA-01401 ?

thanks

richard shea
richardshea at fastmail.fm Received on Tue Aug 06 2002 - 08:42:05 CEST