This content has been marked as final. Show 3 replies
Edward, you see, when you create WF_IN Listener from Oracle Workflow Setup Check All homepage, really they implemented as database JOBs.
So, connect to database as sys and select from DBA_JOBS, look if there is any job with text ("what" column) like "Wf_Event.Listen('WF_IN')".
If there is one or several - check there status, if they are working correctly (broken = 'N', failures = 0).
If broken = 'Y' or failures > 0, than you have problems with them!
In this case check if you have set database parameters job_queue_processes=10, and aq_tm_processes=1 as recommended for Workflow.
If it does not help, try to execute dequeue comment manually:
When I try to dequeue manually as you mentioned, I got the following Oracle Error:
ORA-00600: internal error code, arguments: [kwqidrdq: loop], , , , , , , 
ORA-06512: at "OWF_MGR.WF_EVENT", line 1111
ORA-06512: at "OWF_MGR.WF_EVENT", line 761
ORA-06512: at line 2