Code completion errors with ORA-00942

[Gustavo]

Hi,

When I try to use code completion I get the following error:

ORA-06550: line 121, column 16:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 119, column 7:
PL/SQL: SQL Statement ignored

This happens when I try to get code completion for something like:

select * from po.

This only happens in production instance. I tried it with "Use DBA views if available" checked and unchecked. I sent a debug.txt that was generated while it was unchecked.

PL/SQL Developer
Version 7.1.5.1397

Regards,
Gustavo

 

[Marco Kalter]

From the error message it would appear that you do not have select privileges on the sys.all_users view. Can you verify this?

 

[Gustavo]

Indeed, I get ORA-00942 when I try to select this object. I'm checking with our DBAs for changes over the last weekend. I'll post any findings here.

Thanks!