Oracle Error ORA-25279: dequeue as select not supported before 8.2

Oracle Error Message

ORA-25279: dequeue as select not supported before 8.2

Reason for the Error

Dequeue as select not supported before 8.2.

Solution

Dont use select condition while dequeuing