1 Reply Latest reply on Mar 21, 2019 5:56 PM by thatJeffSmith-Oracle

    Cannot view code for plsql package spec and package body in SQLDeveloper 18.3 and 18.4

    rxshah00

      Greetings.

      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 12.1.0.2.190115

       

      One database is running on VMware server with the following kernel:2.6.18-419.0.0.0.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

       

      Thanks.

       

      Message was edited by: rxshah00