Hi Tom,

I am trying to view explain plan for a select statement in Livesql built on 19c oracle version.
I am able to view the explan result using
select * from table(dbms_xplan.display_cursor);
but i see Error: cannot fetch last explain plan from PLAN_TABLE while using select * from table(dbms_xplan.display);
Could you please help me understand .



explain plan for select * from customers where id = 1;

select * from TABLE(DBMS_XPLAN.DISPLAY);

PLAN_TABLE_OUTPUT
Error: cannot fetch last explain plan from PLAN_TABLE

select * from customers where id = 1;

select * from table(dbms_xplan.display_cursor);

PLAN_TABLE_OUTPUT
SQL_ID 92qqjqaghv843, child number 1
-------------------------------------
SELECT O.OBJECT_NAME, O.OBJECT_TYPE, O.STATUS, E.TEXT, E.LINE,
E.POSITION FROM SYS.DBA_OBJECTS O, SYS.DBA_ERRORS E WHERE O.OBJECT_NAME