how to cast ORA-22905 away?

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