Cause: Subscriber is only allowed to dequeue persistent messages See the solution below.
Error solution: Drop the subscriber and re-create it, or dequeue only persistent messages for the subscriber
Database version: Oracle 11g Release 2 (11.2)