Possible bug with "Execute (F8)" function

[A. Durocher]

Hello,

I have found the following behaviour within PL/SQL Developer 10, which leads me to believe it's a possible bug:

- log in to database A
- execute sql statement in SQL Window with Execute icon or F8
- log off from database A but leave SQL Window open
- log in to database B
- Execute icon is disabled and F8 function no longer works

If I do an explain plan on the statement (F5) and then close the subsequent plan window, the Execute icon is reenabled and F8 will work again.

 

[Marco Kalter]

I assume the window connection for database A is not pinned? In that case the window will indeed remain logged off after connecting to database B. To execute the disconnected window for database A, press the * button next to the connection indicator in the status line of the window. This will explicitly log on to database A again, and you will subsequently be able to execute the SQL statement.