Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Modeller: rules violation

_AZ_Jan 5 2010 — edited Jan 11 2010
I defined the column as varchar2(50) not null. and added check constraint:
    ADD CONSTRAINT CK_HDR_entity 
    CHECK ( entity IN ('class' , 'class_periodic' , 'deal' , 'deal_col_periodic' , 'deal_pool_periodic' , 'deal_property_periodic' , 'deal_scol_periodic' , 'deal_tenant_periodic' , 'deal_var' , 'deal_var_periodic' , 'map' )) 
the rules check complains with : "entity default value violated permitted values";

am i missing smth ?

Thank you
Andrew
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 8 2010
Added on Jan 5 2010
7 comments
1,262 views