how to cast ORA-22905 away?

From: Helma <>
Date: Mon, 8 Dec 2008 05:41:13 -0800 (PST)
Message-ID: <>

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?

Thanks a lot! Received on Mon Dec 08 2008 - 07:41:13 CST

Original text of this message