dbms_xplan.display_cursor question

From: GBA-DBA <gba.oraclel_at_gmail.com>
Date: Wed, 25 Feb 2009 15:49:39 -0600
Message-ID: <d7e2170902251349x4ffa2354meaf4125dd57fbd3c_at_mail.gmail.com>

Hi list,

I'm trying to run select * from
table(dbms_xplan.display_cursor(null,null,'ALLSTATS LAST')); in SQL*PLUS (Oracle EE 10.1.0.5.0 64 bit) but i'm getting this error:

select * from table(dbms_xplan.display_cursor(null,null,'ALLSTATS LAST'))

*
ERROR at line 1:
ORA-22905: cannot access rows from a non-nested table item

Is it a feature available in 10g R2 and onwards only?

-- 
Regards
GBA

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 25 2009 - 15:49:39 CST

This message: [ Message body ]
Next message: FMHabash: "RE: Enabling Flashback DB in Production Databases. - Reverse"
Previous message: Baumgartel, Paul: "RE: Enabling Flashback DB in Production Databases. - Reverse"
Next in thread: jaromir nemec: "Re: dbms_xplan.display_cursor question"
Reply: jaromir nemec: "Re: dbms_xplan.display_cursor question"
Reply: Martin Klier: "Antwort: dbms_xplan.display_cursor question"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message