Unable To Display Java Objects Within SQL Developer (Doc ID 2893310.1)

Last updated on SEPTEMBER 06, 2022

Applies to:

Symptoms

On : 22.2.1 version, All Reports

Unable to display Java objects within SQL Developer

Having difficulty displaying schema Java objects through SQL developer v22.2 on an Oracle 19c database. Executed several gather stats on the CDB/PDB with no success. Attempting the same on a non-CDB Oracle 12cR1 database without issue. Same for TOAD for Oracle. The issue seems to be related to SQL Developer.

The only diagnostics information is the screen shot. As noted, within an EBS R12.1.3 environment after upgrade to Oracle 19c, displaying JAVA objects through the SQL Developer GUI just displays "Loading..". If I execute a direct query (SELECT * FROM user_objects WHERE object_type LIKE '%JAVA%') or use the schema browser in TOAD, the java object list in seconds. The issue is with SQL Developer/Oracle 19c. Within an EBS R12.1.3 environment on Oracle 12c, the java objects are successfully displayed.

EXPECTED BEHAVIOR
-----------------------
Need Java objects to display when expand on Java in SQL Developer object navigator


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. connect to db
2. expand on "Java"
It will hang on "Loading"

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.