I'm attempting to dequeue a specific message by its message ID using PL/SQL.
I retrieve the message ID from the queue table, but when I run the dequeue, I get
ORA-25263, no message in queue SCHEMA.QUEUE with message ID C0C68C7D93694022A93157ED55
What am I doing wrong? I also tried hextoraw() on the msgid but that made no difference.