ORA-24228
purge by condition not supported for sharded queues/transactional event queues.
Cause
purge by condition not supported for sharded queue/transactional event queues and hence purge_condition should be NULL.
Action
Call the procedure with purge_condition set to NULL.