java.sql.SQLException: ORA-25226: dequeue failed
--------------------------error----------------------------
java.sql.SQLException: ORA-25226: dequeue failed,
queue PRD_SOAINFRA.EDN_OAOO_QUEUE is not enabled for dequeue
ORA-06512: at
"SYS.DBMS_AQ", line 335
ORA-06512: at "PRD_SOAINFRA.EDN_DEQUEUE_OAOO_DELIVERY", line 14
java.sql.SQLException: ORA-25226: dequeue failed,
queue PRD_SOAINFRA.EDN_OAOO_QUEUE is not enabled for dequeue
ORA-06512: at
"SYS.DBMS_AQ", line 335
ORA-06512: at "PRD_SOAINFRA.EDN_DEQUEUE_OAOO_DELIVERY", line 14
-----------------------------------------------------------
Solution:
begin
dbms_aqadm.start_queue(queue_name => 'PRD_SOAINFRA.EDN_OAOO_QUEUE');
end;
-----------------------------------------------------------
Verify:
select owner,name,enqueue_enabled,dequeue_enabled from dba_queues where name = 'EDN_OAOO_QUEUE' order by 4;
-----------------------------------------------------------
Comments
Post a Comment