Having issue with viewing code for package spec and package body in SQLdeveloper in 18.3 and 18.4 (I have these two versions installed in my machine) after database was migrated to new hardware. We can see only the name of package spec and package body but no procedure/function/variables.
Logged on as schema owner having the packages.
SQL developer is running on Windows 10 64 bit
Both databases are 184.108.40.206.190115
One database is running on VMware server with the following kernel:2.6.18-4220.127.116.11.12.el5 --> everything is fine I can view all code in package body and procedure/functions/variables in package specs.
New copy of database is running on Nutanix AHV with the following kernel: 4.14.35-1844.2.5.el7uek.x86_64 --> here only see name of package spec and package body
Is this a known issue?
With other tools - Toad, PLSQL developer - we can see the code in package spec and package body
Message was edited by: rxshah00
Not a known issue.
use the Log, statements panel to capture the SQL we run to populate the code editor for your package
That will tell you about any missing privileges