Antwort: dbms_xplan.display_cursor question
- From: Martin Klier <Martin.Klier@xxxxxxxxxx>
- To: gba.oraclel@xxxxxxxxx
- Date: Thu, 26 Feb 2009 15:50:57 +0100
Hi,
is it maybe the "set serveroutput off;" issue?
But might be a 10gR1 problem as well, not sure about it.
Regards
Martin
--
Mit freundlichem Gruß
Martin Klier
------------------------------------------------------------------------------
Klug GmbH integrierte Systeme
Lindenweg 13, D-92552 Teunz
Tel.: +49 9671/9216-245
Fax.: +49 9671/9216-112
mailto: martin.klier@xxxxxxxxxx
www.klug-is.de
------------------------------------------------------------------------------
Geschäftsführer: Johann Klug, Roman Sorgenfrei
Sitz der Gesellschaft: Teunz, USt-ID-Nr. DE175481608,
HRB Nr. 2037, Amtsgericht Amberg
oracle-l-bounce@xxxxxxxxxxxxx schrieb am 25.02.2009 22:49:39:
> GBA-DBA <gba.oraclel@xxxxxxxxx>
> Gesendet von: oracle-l-bounce@xxxxxxxxxxxxx
>
> 25.02.2009 22:51
>
> Bitte antworten an
> gba.oraclel@xxxxxxxxx
>
> An
>
> Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
>
> Kopie
>
> Thema
>
> dbms_xplan.display_cursor question
>
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Antwort: dbms_xplan.display_cursor question - Martin Klier
