This content has been marked as final. Show 2 replies
I am using:Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit Production
I have callback procedure registered to my advance queue but it is not working after I recompiled the procedure As per AQ$_AQ_SRVNTFN_TABLE_1_F, It is going to exception queue. How can I find why it is going to exception queue?
select * from SYS.USER_SUBSCR_REGISTRATIONS;
|303||""ALERT_Q"||plsql://callbackEnqueueIndvl||57||FF||1||AQ||DEFAULT||DB REG||0||22-MAY-14 12.17.05.375385000 PM -04:00|
select * from AQ$_AQ_SRVNTFN_TABLE_1_F order by enq_time desc;
|AQ$_AQ_SRVNTFN_TABLE_1_E||AAISqUAACAAAFh3AAQ||F93D79F05F030F5DE043134C100A2FFE||0||3||22-MAY-14 18.104.22.168482000 PM||3.20.92125||5||AQ_SRVNTFN_TABLE_Q_1||0||0||0||0||0||[SYS.AQ$_SRVNTFN_MESSAGE]||PERSISTENT||0||0||2173603|