Oracle Precision - Check generated in Model ORA-01438
Posted: Fri 11 Jul 2014 12:55
Sometimes we have the problem, that the values in model are larger than Oracle column definition.
Example: Oracle type is NUMBER(3,1), but given value is 10000.
If you try to store this to database, on oracle error is generated ORA-01438.
Is there a possibility, to generate automatically an exception, when a value greater then Oracle definition is set to the model value ?
P.S.:
Can this check be generated automatically, if this possibility exists, or must I adapt this manually column by column?
Example: Oracle type is NUMBER(3,1), but given value is 10000.
If you try to store this to database, on oracle error is generated ORA-01438.
Is there a possibility, to generate automatically an exception, when a value greater then Oracle definition is set to the model value ?
P.S.:
Can this check be generated automatically, if this possibility exists, or must I adapt this manually column by column?