Non-Issue: Global PLAN_TABLE in 8.1.7 db

[CTzen]

Marco,

I'm using global temporary PLAN_TABLE. Public synonym created and neccessary permissions granted to PUBLIC.

For some reason, when I run 7.0.3RC1 against 8.1.7 database, PLD doesn't "like" it and suggests to create new plan_table. It works fine with 9.2.0 database though.

It's a minor issue though, hopefully I'll upgrade that database soon.

 

[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 (when it suggests to create a new plan_table) and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[CTzen]

Please ignore this one, there was another synonym for PLAN_TABLE that caused all the problems.