1 Reply Latest reply: Oct 29, 2012 4:53 AM by user648708 RSS

    error when dequeing

    Roy4321
      One question regarding an error i am getting:
      The record was queued into the queue table. The dequeue process has the remove option after dequeue. But after dequeue the column DEQ_TID in queue table is updated with a value and the record is not removed from queue.
      The problem is when i execute the dequeue again the session is hanged: below is the dequeue code:

      am i missing smthng?
      error i am getting:
      ORA-25326: Array dequeue operation failed for message at index 1
      ORA-03135: connection lost contact

      Edited by: Roy Mathew on Oct 29, 2012 12:40 AM
        • 1. Re: error when dequeing
          user648708
          Hello,

          with only these few informations it is difficult to make a diagnosis.
          How did you setup your dequeue using DBMS_AQ.DEQUEUE ( dequeue_options ) ?
          I assume, that there is a commit statement without error.

          Kind regards,

          WoG