My Oracle Support Banner

"/ by zero" Exception When Run Any Query in SQL Developer (Doc ID 2425167.1)

Last updated on NOVEMBER 03, 2021

Applies to:

Oracle SQL Developer - Version 4.1.5 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
On : 4.1.5.21 version, SQL Developer

Symptoms

When trying to run any query in SQL Developer, it returns no records and the following message.

ERROR:

java.lang.ArithmeticException: / by zero
at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:1387)
at oracle.jdbc.driver.OracleCallableStatement.<init>(OracleCallableStatement.java:102)
at oracle.jdbc.driver.T2CCallableStatement.<init>(T2CCallableStatement.java:110)
at oracle.jdbc.driver.T2CDriverExtension.allocateCallableStatement(T2CDriverExtension.java:96)
at oracle.jdbc.driver.PhysicalConnection.prepareCall(PhysicalConnection.java:2111)
at oracle.jdbc.driver.T2CConnection.prepareCall(T2CConnection.java:57)
at oracle.jdbc.driver.PhysicalConnection.prepareCall(PhysicalConnection.java:2049)
at oracle.jdbc.driver.T2CConnection.prepareCall(T2CConnection.java:57)
at oracle.dbtools.db.OracleUtil.checkAccess(OracleUtil.java:409)
at oracle.dbtools.db.DBUtil.hasAccess(DBUtil.java:1898)
at oracle.dbtools.raptor.query.QueryUtils.checkNonOracleAccess(QueryUtils.java:589)
at oracle.dbtools.raptor.query.QueryUtils.getQuery(QueryUtils.java:399)
at oracle.dbtools.raptor.query.QueryUtils.getQuery(QueryUtils.java:250)
at oracle.dbtools.raptor.query.ObjectQueries.getQuery(ObjectQueries.java:43)
at oracle.dbtools.raptor.navigator.db.xml.XmlObjectFactory.createFolderInstance(XmlObjectFactory.java:60)
at oracle.dbtools.raptor.navigator.db.xml.XmlTypeOwnerInstance.listTypeFolders(XmlTypeOwnerInstance.java:93)
at oracle.dbtools.raptor.navigator.db.impl.TypeContainerTreeNode.loadTypeFolders(TypeContainerTreeNode.java:111)
at oracle.dbtools.raptor.navigator.db.impl.DatabaseTreeNode$LoadTask.doWork(DatabaseTreeNode.java:183)
at oracle.dbtools.raptor.navigator.db.impl.DatabaseTreeNode$LoadTask.doWork(DatabaseTreeNode.java:112)
at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:621)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

 
This problem happened suddenly.  It was working fine before for this particular (offending) user. With a different user's account, it works fine.

Yet, running query on another user's laptop works fine using the same offending user.

This works fine in SQL*Plus.

Changes

No changes were done in SQL Developer.

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.