Team,

we are using Oracle PL/SQL Developer for Database development, but getting this error while invoking dbms_xplan.display_cursor.

<error>
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
SQL_ID 9m7787camwh4m, child number 0
begin :id := sys.dbms_transaction.local_transaction_id; end;
NOTE: cannot fetch plan for SQL_ID: 9m7787camwh4m, CHILD_NUMBER: 0
Please verify value of SQL_ID and CHILD_NUMBER;
It could also be that the plan is no longer in cursor cache (check v$sql_p
</error>

Could you help us to resolve this? more details available at the below link.

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9530273800346286574