Skip to Main Content

FreeSQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't use my_user_xplan

Peter BankeMar 18 2026

As a newcomer to PL/SQL, I am trying to follow the examples on Oracle FreeSQL. Even though I can find a valid sql_id in my_user_sql, I cannot get the execution plan from my_user_xplan.display_cursor (select plan.* from my_user_xplan.display_cursor('XYZ') plan;). I get the error "ORA-20002: SQL_ID not found or no execution plan available." Am I doing something wrong/misunderstanding?

Comments
Post Details
Added on Mar 18 2026
3 comments
43 views