Hi,
we are using PL/SQL Developer version 15.0.4.2064 and recently one of our developer got a strange problem with explain plan. I was able to reproduce it.
1- Create a new dummy table:
create table test_date(col1 number, col2 date);
2- In SQL Window run the query
select col1,col2 from test_date;
Now select the query and press F5 to execute the explain plan. This is working correctly
3- In SQL Window run the query
select to_char(col2,'YYYYMMDD') from test_date;
Now select the query and press F5 to execute the explain plan. We are getting a message "Plan table does not exist, create it?" If we answer No the explain plan is not executed and if we answer yes we are getting an error message "Error creating plan table: Not logged on"
4- Another test, in SQL Window run the query
select to_char(trunc(col2),'YYYYMMDD') from test_date;
Now select the query and press F5 to execute the explain plan. This is also working correctly
Can you confirm if this is a bug or if I am missing something.
Regards
Martin