Hi all,
I have a need to implement some advanced queuing functionality for a customer. I am new to this feature, so I started out attempting to implement a demo I found here:
http://www.oracle-developer.net/display.php?id=411
The demo setup worked well and provided what looked like a great template to expand upon. I created my own custom TYPE, Queue Table, Queue, and Callback procedure in PL/SQL. Unfortunately, the Callback functionality did not work. I modified my code repeatedly until it was a line by line copy of the demo from the above link, but with my custom objects. Where the demo worked, mine refused to run properly. I could manually enqueue and dequeue messages, but the registered callback procedure refused to run. It didn't throw exceptions of any kind.
Eventually, I started modifying the demo objects and code to include my custom functionality and everything worked. I'm fairly certain that means that my code/logic isn't the problem, but I would really like to understand what I was doing incorrectly.
I've attached the relevant code to this message and would love if someone could help me find my problem and help me understand what I was doing wrong.
Thanks in advance,
-Mike