Problem with Explain Plan

[MartinF]

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

 

[Marco Kalter]

This seems to work fine when I try it. Maybe this is an environment problem. Can you start PL/SQL Developer without connecting, go to Help > Support Info and send me the text from the "Info" tab page?

 

[jhughes]

I tried it using the same PL/SQL Developer version 15.0.4.2064 against an older Oracle 12.1.0.2.0 DB. I did NOT encounter any issue. I used the Command window to run the Create statement. I used a single SQL Window to run both statements and I left the first Explain Plan window open.