Oracle Error ORA-25257: consumer must be specified with a multi-consumer queue

Oracle Error Message

ORA-25257: consumer must be specified with a multi-consumer queue

Reason for the Error

An attempt was made to register on a multi-consumer queue without specifying a consumer in the subscription string.

Solution

Specify a consumer in the subscription string.