Browsing Database Objects Generates "Java.Lang.Arithmeticexception: / By Zero" Error (Doc ID 1404163.1)

Last updated on DECEMBER 01, 2016

Applies to:

Oracle SQL Developer - Version 3.0 and later
Information in this document applies to any platform.

Symptoms

Character set:
CL8KZ1048

Problem
Connection to tables gives the following error message

Error

java.lang.ArithmeticException: / by zero
at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:1291)
at oracle.jdbc.driver.T4CPreparedStatement.<init>(T4CPreparedStatement.java:29)
at oracle.jdbc.driver.T4CDriverExtension.allocatePreparedStatement(T4CDriverExtension.java:67)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3523)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3409)
at oracle.dbtools.raptor.controls.grid.OracleRSTModel.prepareStatement(OracleRSTModel.java:81)
at oracle.dbtools.raptor.controls.grid.ResultSetTableModel.openResultSet(ResultSetTableModel.java:444)
at oracle.dbtools.raptor.controls.grid.ResultSetTableModel.fetchNext(ResultSetTableModel.java:183)
at oracle.dbtools.raptor.controls.grid.ResultSetTableModel$4.doWork(ResultSetTableModel.java:622)
at oracle.dbtools.raptor.controls.grid.ResultSetTableModel$4.doWork(ResultSetTableModel.java:606)
at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)


What works:
UTF8 character set
Connection to Sql*plus

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms