Re: dbms_xplan.display_cursor question

If I can recall it correctly the problem is in using 'select * ...'. Try instead explicit reference of the column:

SELECT PLAN_TABLE_OUTPUT FROM table(DBMS_XPLAN.DISPLAY('plan_table', 'N1','ALL')); Yes, and searching Oracle documentation suggests that the display_cursor function is available in 10g Release 2.

HTH Jaromir

> 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