What prevents Code Assistant from displaying column names?

[Ron E]

We're still running ver. 8.0.2.1505, DB ver. 10.2.

We have one table in one schema where the code assistant refuses to display the column names, either automatically or when you press F6. It does apparently try to retrieve the column names, because it hesitates for a second after you type in the period or press F6, but nothing seems to come back. It'a a fairly new table, but we can't see anything unusual about it how it's defined.

This happens across several users, so it doesn't seem to be settings related. Is there anything in the catalog which would confuse the code assistant?

 

[Marco Kalter]

Could it be that there is a user with the same name as the table? This ambiguity can cause this issue.

 

[Ron E]

I doubt that a user name is it. I just talked to him again, and they made some changes to some tables recently, and now he says it happens to all the tables in two schemas, called IFM_FACT and IFM_DIM, which don't follow the pattern of our standard user names. The table names are pretty unusual, too.

Is it possible that the older version of Developer is getting messed up by some newer entries in the database catalog or something? I know we've had that with Microsoft Access and recently created tables, although that's using ODBC.

 

[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).