Re: dbms_xplan.display_cursor question
- From: "jaromir nemec" <jaromir@xxxxxxxxxxxx>
- To: <gba.oraclel@xxxxxxxxx>
- Date: Thu, 26 Feb 2009 15:42:08 +0100 (CET)
Hi GBA,
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
Other related posts: