When using Domain-Enum, there are two different error messages when you try to insert an invalid-item. Re-producing script available.
The first, somewhat confusing error, is when i used the Domain-definition as a Constant to insert the values:
ORA-00984: column not allowed here.
The more clear message is :
ORA-11534: check constraint (SCOTT.SYS_C009881) involving column COLOR due to domain constraint SCOTT.SYS_DOMAIN_C00352 of domain
I far more prefer the 2nd error. Although I can see why the first one would appear.
Any idea to change the error in first case ?
Script: demo_enum_6anomaly.sql
or https://drive.google.com/file/d/11bk1nGPd0hJyod-sQVO-fZamYNV6omQE/view?usp=sharing
note: the error-text is shorter, more concise in SQL*Plus. SQLcl adds a lot of helpful stuff, but this almost obscures the errors.
Screenshot: