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'));
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
Post a Comment