Issue

If you are executing a simple SQL query like

SELECT * FROM Articles

against an Oracle database from within a .NET application and you are getting an exception like

System.DivideByZeroException: Attempted to divide by zero.

In German:

System.DivideByZeroException: Es wurde versucht, durch 0 (null) zu teilen.

Cause

Probably a bug in the ODAC .NET drivers/layers. One user in the Oracle forums faced the same issue.

Resolution

In my case it was as simple as replacing the asterisk (“*”) with an explicit list of columns I wanted to query for.

E.g.

SELECT Name1, Price, Description FROM Articles

After that modification, I was successfully able to run the query and get results.