dbms_xplan.display_cursor question
- From: GBA-DBA <gba.oraclel@xxxxxxxxx>
- To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 Feb 2009 15:49:39 -0600
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
Other related posts: