error when dequeing
Roy4321Apr 29 2011 — edited Oct 29 2012One 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