2 Replies Latest reply: Jun 11, 2014 12:06 AM by User13260331-Oracle RSS

    AQ notification callback procedure not working . It is going to exception queue

    spur230

      I am using:Oracle Database 11g Enterprise Edition Release 11.2.0.3.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://callbackEnqueueIndvl57FF1AQDEFAULTDB REG022-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_EAAISqUAACAAAFh3AAQF93D79F05F030F5DE043134C100A2FFE0322-MAY-14 12.26.23.237482000 PM3.20.921255AQ_SRVNTFN_TABLE_Q_100000[SYS.AQ$_SRVNTFN_MESSAGE]PERSISTENT002173603

       

      Thanks.