ORA-29983: Unsupported query for Continuous Query Notification When Auto-Refresh Turned On (Doc ID 1360848.1)

Last updated on MARCH 10, 2016

Applies to:

Oracle JDeveloper - Version 11.1.1.5.0 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Feb-2013***

Symptoms


In your ADF application, you defined list of values (LOVs) based on View Objects with the auto-refresh turned on.

When the applications accesses an Oracle Database 10g, this application works correctly.
After you migrated to Oracle Database 11gR2, it fails with an error: ORA-29983: Unsupported query for Continuous Query Notification

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