Advance Queue: Msg is being enqued in the table but it is not being Dequeued.
I am running Oracle Enterprise Server 11.1.0.6 on Solaris 10 sparc. Adhance Queues has been configured & the following steps have been done. Hoewever, the msg is being enqued in the table but it is not being Dequeued. It seems that the notification procedure is not executed.
Steps done:
- create the notification procedure
- register the callback procedure
- enqueue a message
- NOTHING HAPPENS
select * from SYS.REG$; (o/p is below)
REG_ID 7
SUBSCRIPTION_NAME "AUBUATR3"."GWAQ_FCUBS_NOTIF_DATA_Q"
LOCATION_NAME plsql://AUBUATR3.gwpks_notification.pr_notif_callback
USER# 96
USER_CONTEXT 01
CONTEXT_SIZE 0
NAMESPACE 1
PRESENTATION 0
VERSION 0
STATUS 0
CONTEXT_TYPE 0
QOSFLAGS 0
PAYLOAD_CALLBACK