Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Problem with dbms_xplan.display (ORA-22905)

Problem with dbms_xplan.display (ORA-22905)

From: Thomas Kellerer <BDHLDUUTPRWS_at_spammotel.com>
Date: Fri, 21 Apr 2006 11:02:34 +0200
Message-ID: <4arldaFtcs34U1@individual.net>


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 Sony
Received on Fri Apr 21 2006 - 04:02:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US