dbms_aq.register not calling procedure
Oracle version 10.2.0.5 SE
I have an application that is set to insert rows on a table on my database. These rows represents messages that should be processed as quickly as possible by my database application. I can't use a trigger because the vendor or the external app claims that if so, I would have retention problems, other of his customers tried and had big trouble. His solution is rather weird (a session running an infinite loop), seems he never heard of rollback, undo and other Oracle features, in other words, he doesn't know how Oracle works.
Well, doing some research, I found that Advanced Queuing would be perfect. It has a feature where you register a pl/sql procedure as subscriber and this procedure would be automatically called by the AQ process when I add a message to the queue.
I have an application that is set to insert rows on a table on my database. These rows represents messages that should be processed as quickly as possible by my database application. I can't use a trigger because the vendor or the external app claims that if so, I would have retention problems, other of his customers tried and had big trouble. His solution is rather weird (a session running an infinite loop), seems he never heard of rollback, undo and other Oracle features, in other words, he doesn't know how Oracle works.
Well, doing some research, I found that Advanced Queuing would be perfect. It has a feature where you register a pl/sql procedure as subscriber and this procedure would be automatically called by the AQ process when I add a message to the queue.
0