2 Replies Latest reply on Feb 12, 2015 8:54 PM by Vadim Tropashko-Oracle

    Bug: SQL Developer 4.0 and 4.1 Package Body Details inaccurate

    user4966038

      I went through the trouble of recompiling the SYS schema with PLSQL_CODE_TYPE = Native and PLSQL_OPTIMIZE_LEVEL = 3. I found that it was unwise to change the PLSQL_OPTIMIZE_LEVEL for the Package Specifications under SYS, so I left them alone. When I query the ALL_PLSQL_OBJECT_SETTINGS view, it shows me that my Package Bodies are correctly compiled at Level 3 and the Specifications are still at 2. However when I look at the details tab in either SQL Developer 4.0 or the latest 4.1 Early Adopter it shows the it is at PLSQL_OPTIMIZE_LEVEL = 2. I did a test for the PLSQL_CODE_TYPE and the Body details in SQL Developer also follow the Specification and not the true values. I used the below query to verify the true compile settings.

       

      SELECT owner,
             name,
             type,
             PLSQL_OPTIMIZE_LEVEL,
             PLSQL_CODE_TYPE
        FROM ALL_PLSQL_OBJECT_SETTINGS
       WHERE owner in ('SYS')
         AND type IN ('PACKAGE', 'PACKAGE BODY')
       order by 1,2,3;
      
      
      

       

      Thanks,

      Steven Wilson