Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Problem with dbms_xplan.display (ORA-22905)
Hello,
I have a strange problem here with the dbms_xplan function.
When I run
SELECT * FROM tabl(dbms_xplan.display());
everything is fine. And the information is displayed.
But when I try to provide a statement ID:
SELECT * FROM tabl(dbms_xplan.display('PLAN_TABLE', 'myID'));
I get the following error:
ORA-22905: cannot access rows from a non-nested table item
This is with 9.2.0.7.0 running on a Linux server. When I do the same thing on my Laptop running 9.2.0.1.0 (Windows XP Prof) the statement is working. On another server running 9.2.0.7.0 with HP/UX the statement is working as well.
What Am I missing here?
Regards
Thomas
-- It's not a RootKit - it's a SonyReceived on Fri Apr 21 2006 - 04:02:34 CDT