Dequeue by condition from secure queues causes ORA-1427 while querying from _F view (Doc ID 1590697.1)

Last updated on DECEMBER 08, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms


While using dequeue by condition , dequeue from  secure queues  causes ORA-01427 while querying from _F view.
 

 

Changes

Subscribe to a queue, receive something, drop subscribing user, create it again and subscribe to the queue again

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