Problems with Code Assistant

[Kamn]

Hi, guys,

Strange thing with PL/SQL 8 - Code Assistant does not seem to auto complete column values for one given database. When writing a simple select statement the Assistant would show the available tables for the user selected. But when I put an alias on the table and try to give some 'where' clause, Code Assistant would not popup. Manually calling it would also not help - no popup with suggestions is shown.

For example

select * from misc.[1]customer c where c.[2]id > 100000;

Code assistant shows just fine at position [1], but would not work at position [2].

For all other databases it runs fine. Also, for the database with the auto complete problem, PL/SQL 7 auto completes like a charm. It is worth noting that under 'Users' I have selected MISC and for filter I have shown all objects.

 

[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 or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[Kamn]

Sent

 

[Kamn]

So, it seems that PL/SQL 8 is not working for databases with Data Guard enabled. This s*cks. No DB Admin is crazy enough to disable data protection just because of some Code assistant.

Going back to PL/SQL 7.