Re: Can't select * from v$aq

From: Yong Huang <yong321_at_yahoo.com>
Date: 31 May 2001 07:31:34 -0700
Message-ID: <b3cb12d6.0105310631.674eb188@posting.google.com>

Somebody sent this to me:

Looks like bug 1103378 "SELECT FROM V$AQ VIEW FAILS WITH ORA-604 AND ORA-1001" doesn't appear to be fixed yet

Yong Huang
yong321_at_yahoo.com

I wrote earlier:

> 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
Received on Thu May 31 2001 - 09:31:34 CDT