Re: how to cast ORA-22905 away?

From: Helma <helma.vinke_at_hotmail.com>
Date: Mon, 8 Dec 2008 06:18:48 -0800 (PST)
Message-ID: <f79830a4-f0e9-4fc7-a0ff-6d4a4057226b@l16g2000yqo.googlegroups.com>


On Dec 8, 2:52 pm, Thomas Kellerer <YQDHXVLMU..._at_spammotel.com> wrote:
> Helma, 08.12.2008 14:41:> SQL> SELECT * FROM TABLE(dbms_xplan.display
> > ('PLAN_TABLE','p10','BASIC'));
>
> > SELECT * FROM TABLE(dbms_xplan.display('PLAN_TABLE','p10','BASIC'))
> >               *
> > ERROR at line 1:
> > ORA-22905: cannot access rows from a non-nested table item
>
> > According to Dr Google i have to cast this value. Whatever example i
> > try , i cannot get it to work ( i haven't seen an example with the
> > xplan.display). Can anyone give me the right syntax?
>
> You need to replace the * with an explicit reference to the column:
>
> SELECT plan_table_output
> FROM TABLE(dbms_xplan.display('PLAN_TABLE','p10', 'BASIC'))
>
> Thomas

Aha! Thanks, that worked. Received on Mon Dec 08 2008 - 08:18:48 CST

Original text of this message