Code Assistant? ORA-00942

[G Vetter]

In a SQL window, I have the start of a query: "select * from member m". If I go back, replace the "*" with "m." and wait for the prompting list of columns, I get an error message:
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.

The SQL window is all that is open, and I am a Normal user. If I go to Code Assistant in Preferences and uncheck everything, I don't get the error, but also don't get any helpful list.

 

[Marco Kalter]

Can you let me know your PL/SQL Developer version?

 

[G Vetter]

7.0.3.1123 01.24101

 

[Marco Kalter]

Okay. 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.

 

[G Vetter]

I ran PL/SQL Developer several times with the debugsql parameter, reproduced the problem every time, but no debug file was created.

 

[G Vetter]

Oops, our DBA told me what the problem is. Oracle has a table ALL_USERS to which I have to be granted access for Code Assistant to work. Looks OK now.

 

[Marco Kalter]

Okay. Strange that there is nog debug.txt file though.