No, that’s not what I meant. I just described what kind of values are retured for Scale and Precision in case you use aggregation functions (both will be zero). I’m not the maintainer of the Hibernate Code but a quick look at method “org.hibernate.dialect.OracleDialect.resolveSqlTypeDescriptor()” shows that case:

jdbcTypeCode = java.sql.Types.NUMERIC AND Scale = 0 AND Precision = 0

…is not properly handled. I will return type INTEGER (as you've mentioned) but it should be BIGINTEGER.

So, yes, from my point of view this is a bug. You will pretty much always loose precision in case of using aggregations functions.

Bye,

Ralf