My Oracle Support Banner

Selecting ROWNUM Pseudo Column Fails with ORA-1446 if ResultSet.TYPE_SCROLL_SENSITIVE Is Specified. (Doc ID 2135872.1)

Last updated on OCTOBER 31, 2022

Applies to:

JDBC - Version to [Release 12.1]
Information in this document applies to any platform.


If the program specifies ResultSet.TYPE_SCROLL_SENSITIVE; for example:

selecting ROWNUM pseudo column fails with :

ORA-1446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc.
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(
at oracle.jdbc.driver.OracleStatement.refreshRowsInternal(
at oracle.jdbc.driver.OracleStatement.refreshRows(
at oracle.jdbc.driver.InsensitiveScrollableResultSet.refreshRows(
at oracle.jdbc.driver.SensitiveScrollableResultSet.refreshRows(
at oracle.jdbc.driver.InsensitiveScrollableResultSet.refreshRow(
... 3 more

The issue occurs with JDBC and, but it does not reproduce with JDBC




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

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