ORA-01791: not a SELECTed expresssion

SQL query runs perfectly fine in 11.2.0.3 and not in 11.2.0.4 and reported with ORA-01791 error.

If the error “ORA-01791: not a SELECTed expresssion” is reported in 11.2.0.4 release then it’s a expected behavior and NOT a bug.

Solution:

Include the “order by” clause column in the SELECT statement.

Note: MOS ID: 1600974.1

Advertisements

About Raheel Syed

Oracle DBA
This entry was posted in Troubleshooting and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s