DBMS_XPLAN error....anyone seen this one before?

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Fri, 7 Jul 2006 07:28:43 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF2708AC4FF5@AABO-EXCHANGE02.bos.il.pqe>

SQL> select * from table(dbms_xplan.display);

PLAN_TABLE_OUTPUT

---

---

---

An uncaught error happened in fetching the records : ORA-30929: ORDER SIBLINGS BY clause not allowed here
ORA-30929: ORDER SIBLINGS BY clause not allowed here

2 rows selected.

Fairly complex query, Oracle 9.2.0.5 on Sparc Solaris 8.

--

Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

Ours is the age that is proud of machines that can think and suspicious of men who try to. --H. Mumford Jones, 1892-1980

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jul 07 2006 - 06:28:43 CDT