Oracle Error ORA-25245: agent name cannot be specified if address is a single-consumer queue or an exception queue

Oracle Error Message

ORA-25245: agent name cannot be specified if address is a single-consumer queue or an exception queue

Reason for the Error

The agent name for the agent in the LISTEN call was specified when the agent address was a single-consumer queue or an exception queue.

Solution

Do not specify the agent name.