Alejandro Pancani writes:

... select sum(hours) from task where id_resource=3D14

returns 4 under zope but if I test it under sql_plus it returns 4.5

Does anybody have any idea? I=B4m using an Oracle 8i database conected to zope with ZOracle DA Produc= t We use ZOracleDA with Oracle 8i and get floats (even when we do not want them).

However, the DCOracle module packaged with ZOracleDA was quite old (when we downloaded ZOracleDA). Fetching an up-to-date DCOracle and putting it into ZOracleDA had drastically improved the interaction between Zope and Oracle. Maybe, ZOracleDA is still bundled with an outdated DCOracle? Dieter