Re: Can't select * from v$aq

I could duplicate the bug on 8.1.6.3.0 windows nt with SQL*Plus 8.0.6.0.0.
I could NOT duplicate the bug on 8.1.6.3.0 windows nt with SQL*Plus 3.3.4.0.0.
It seems to be a SQL*Plus bug.

Marc

>>>>>>>>>>>>>>>>>> Oorspronkelijk bericht <<<<<<<<<<<<<<<<<<

Op 2001-05-30, 18:01:14, schreef john.darrah_at_usa.net (John Darrah) over

het thema 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 th
 is
> > 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 checke
 d
> > 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 Fri Jun 01 2001 - 00:52:19 CDT