Dear All!

Please, help me with this: we run Oracle 9 without any bumps except one:
when an AVG function is called, and the avg is not a round value, then NHibernate cannot read the value from the datareader (throws overflow exception).
The datareader's column type is decimal, the avg is relatively small (4.5xxxxxx).
If the AVG is more rounded (like 4.45), works great!

(Using Oracle .NET connector)

Any ideas?

Thanks,

Adam

We found out, that it is actually an oracle driver problem.
When using OLE connection, it works great, but with native Oracle .NET driver, it throws exception.

Damn.

Any comments?

Thanks,

Adam

Try tu use ROUND(AVG(column), 5)