Explain plan not working on version 8.0

[Davide Bizzocchi]

Hi, I just upgraded to version 8, and the Explain Plan windows doesn't work anymore.
When I launch Explain Plan the program comes out with the error:
ORA-00955: name is already used by an existing object
and then it suggests me to create Plan table. When I click on Ok button, ORA-00955 comes out again.

Seems that I have to drop some table, so Developer can re-create it, but the message doesn't say which table...

Thanks for your help

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[Davide Bizzocchi]

Sure, I sent the file by email.

 

[Marco Kalter]

Thanks. It seems that PL/SQL Developer is using OCI7 mode, and this may cause the problem. Can you go to Tools > Preferences > Oracle / Connection and check if "Force OCI7 mode on OCI8" is enabled? If it is enabled, disable it, restart PL/SQL Developer, and try again.

 

[Davide Bizzocchi]

Ok, now it works!
Thank you for the support.

Davide