dbms_xplan.display errors

Examples from 9.2.0.8


select * from table(dbms_xplan.display( format=>'ALL'));

Error:
ORA-00907: missing right parenthesis
Solution:
select * from table(dbms_xplan.display( null, null , 'ALL' ));


Error:
ORA-22905: cannot access rows from a non-nested table item
Solution:
select plan_table_output from table(dbms_xplan.display(null, null , 'ALL'));

Comments