Antwort: dbms_xplan.display_cursor question
From: Martin Klier <Martin.Klier_at_klug-is.de>
Date: Thu, 26 Feb 2009 15:50:57 +0100
Message-ID: <OF79F7D63E.15B4CBBF-ONC1257569.00516165-C1257569.00518DC4_at_klug-is.de>
Hi,
Date: Thu, 26 Feb 2009 15:50:57 +0100
Message-ID: <OF79F7D63E.15B4CBBF-ONC1257569.00516165-C1257569.00518DC4_at_klug-is.de>
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_at_klug-is.de 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_at_freelists.org schrieb am 25.02.2009 22:49:39:Received on Thu Feb 26 2009 - 08:50:57 CST
> GBA-DBA <gba.oraclel_at_gmail.com>
> Gesendet von: oracle-l-bounce_at_freelists.org
>
> 25.02.2009 22:51
>
> Bitte antworten an
> gba.oraclel_at_gmail.com
>
> An
>
> Oracle Discussion List <oracle-l_at_freelists.org>
>
> 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
-- http://www.freelists.org/webpage/oracle-l