Unable to view Q table - OCI-21700: object does not exist or is marked for delete

[WexSoft]

Version 14.0.2.1969 64 bit WIndows 10

Connected to an Oracle 11g database.

Trying to select from a queue table:

"OCI-21700: object does not exist or is marked for delete"

I am able to do the same select no problem in Oracle SQL Developer, so it appears to be an issue with PL/SQL Developer.


View attachment OCI_Issue_Support_Info.txt

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer 14\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 14 directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer 14).

 

[WexSoft]

Hi Marco

See Debug.txt file attached.

If you need any more details, let me know.
View attachment Debug.txt

 

[Marco Kalter]

Thanks. Can you send me the DDL for table milk.flash_stag_q_table?