This content has been marked as final. Show 3 replies
Not sure this is the [only] reason, but you didn't specify the payload type for the PL/SQL callback. Your callback specification should be either 'plsql://SPIN_D.dequeue_messages.dequeuecust?PR=0' for raw payload or 'plsql://SPIN_D.dequeue_messages.dequeuecust?PR=1' for ADT payload encoded in XML. Also, your AQ$_REG_INFO.NAME attribute is missing queue schema name.1 person found this helpful
I have implemented the said changes but still it doesn't give automatic notification for dequeue. Are there any .ini parameters to be verified ?
Thanks in advance.
Make sure job_queue_processes is not set to 0 - there must be at least one active job scheduler process for notifications to work.