Re: Can't select * from v$aq

I was able to duplicate this on both 8.1.6 linux and 8.1.7 solaris 8. I would say it is a bug. Do you have access to Metalink to log a TAR?

yong321_at_yahoo.com (Yong Huang) wrote in message news:<b3cb12d6.0105291043.280fc583_at_posting.google.com>...
> Our database is 8.1.7 Enterprise Ed. OS Sparc Solaris 2.6. I have this
> 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
>
> select count(*) or select distinct <column_name> from v$aq works.
> select * from v$aq works in svrmgrl, just not in SQL*Plus.
>
> I can't find anything on Metalink indicating this is a bug. I checked
> most if not all objects created by dbmsaqad.sql and catqueue.sql and
> they exist. I made sure all objects in SYS and SYSTEM valid. Enabled
> tracing with 10046 level 12 and looked at the trace file (please go to
> http://www.stormloader.com/yonghuang/CannotSelectv$aq.txt for it;
> thanks). Nothing unusual.
>
> Any help is appreciated.
>
> Yong Huang
> yong321_at_yahoo.com
Received on Wed May 30 2001 - 11:01:14 CDT