Hello, I'm looking for some help to which I've searched and can not find any answers.
Database version is 18.104.22.168.3
I have a AQ user who owns the message queue and another user who owns the enqueue and callback procedures. The set up needs to be this way. Enqueue works fine -- I can see the message in the queue table. However, the callback procedure never appears to execute and when I look at the trace file generated from the scheduler job, I see this:
"For raw message payload for the PLSQLCALLBACK procedure, use plsql://schema.procedure?PR=0. For user-defined type message payload converted to XML for the PLSQLCALLBACK procedure, use plsql://schema.procedure?PR=1"
My looking into the matter prior to posting here was taking me down a different road, but per your advice, I added ?PR=0 to the end of the plsql string and re-ran it to no effect --- one way or the other. The results were exactly the same. I've left ?PR=0 in there as it should be.