ORA-00942 with code assistant

[mike]

I'm using version 7.1.3.1381. In instances where I have limited access to tables, I'm getting an "ORA-00942 Table or view does not exist" error each time the code assistant tries to help. Prior versions ignored the Oracle error and the code assistant just didn't work. I like the old way better.

P.S. I noticed another post with version 7.0.3.1123, so maybe I just haven't noticed it recently?

 

[Marco Kalter]

Can you go to Tools > Preferences > Oracle and check if "Use DBA views if available" is enabled? If it is, can you disable it and try again?

 

[mike]

Yes - "Use DBA views if available" was enabled. Disabling it fixed it.

Thank-you,

Mike