Hi!
we try to use the new (and fantastic!) Oracle Advance Queueing (AQ) feature for message passing between different db jobs.
But on some workstation when we try a select on the AQ statistic table v$aq, we get the following error:
SQL> select * from v$aq;
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
no rows selected
It has nothing do to with privilidges, sometimes it works, sometime not - same user.
Does anybody can give us a hint?
