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?