[Toad 12.10.0.30] Error: ORA-00904: "SYS"."DBMS_JAVA"."LONGNAME": invalid identifier

Toad for Oracle
1

Recently, we have migrated our Oracle database 11g to Oracle 19c.
Connection is working fine and on Toad for Oracle, we see the error.

Error: ORA-00904: "SYS"."DBMS_JAVA"."LONGNAME": invalid identifier

Below is what I get when spool.

-- Session: xx@yyy
-- Timestamp: 21:12:46.150
Select OBJECT_NAME, OBJECT_TYPE, STATUS, SYS.DBMS_JAVA.LONGNAME(OBJECT_NAME) LONGNAME, LAST_DDL_TIME, OBJECT_ID, CREATED, :own OWNER
from sys.user_objects
where object_type in ('JAVA CLASS', 'JAVA SOURCE', 'JAVA RESOURCE', 'JAVA DATA');
:own(VARCHAR[3],IN/OUT)='MIS'

-- Session: xx@yyy
-- Timestamp: 21:12:46.232
Select OBJECT_NAME, OBJECT_TYPE, STATUS, SYS.DBMS_JAVA.LONGNAME(OBJECT_NAME) LONGNAME, LAST_DDL_TIME, OBJECT_ID, CREATED, :own OWNER
from sys.user_objects
where object_type in ('JAVA CLASS', 'JAVA SOURCE', 'JAVA RESOURCE', 'JAVA DATA')
Error: ORA-00904: "SYS"."DBMS_JAVA"."LONGNAME": invalid identifier

Any help is highly appreciated.

2

Ok, I see you are on version 12.10.

What are you doing/where are you clicking in Toad to get this error?

The problem will go away if you are granted EXECUTE on DBMS_JAVA, but if you let me know which window you are in, where you are clicking, etc, I may be able to tell you what to uncheck in Toad so that it doesn't run this SQL.