Arquivo da tag: Fun

Oracle DB Playing Tricks On Me

Earlier at work I spent one hour trying to understand why I was unable to insert some data in a table – Oracle Database.

More specifically I was trying to insert a number value (BigDecimal(100)) from a Java application, but I always got the follow error: “ORA-01438: value larger than specified precision allowed for this column”.

I thought “Ok, let’s check the column’s properties and confront that with the value I’m trying to insert…”

Continuar lendo