CODEWITHSUNDEEP
c#oracle-databaseentity-framework
user2674202
user2674202

Reputation: 35

Validate ORA-01438: value larger than specified precision allowed for this column

I'm using C# with the Entity Framework Model and Oracle. When I want to add a value then it gives me this error.

Of course I know what the problem is: When inserting or updating records, a numeric value was entered that exceeded the precision defined for the column.

But now I want to ask how I can validate this. I want to check if a value will match with the precision of a column.

The precision of the column should not be given, it should be read from the database so I can use it universal for all of my tables.

Can anyone please help me?

Thank you in advance

Upvotes: 2

Views: 1518

Answers (1)

liao
liao

Reputation: 41

when Error ORA-01438 happens, It mean that there is a fault in the database table column design (if the data is correct), it is not able to contain the data.

So you should not to check the precision of a column but ask the designer to modify the design.

Upvotes: 1

Related Questions