Toad World® Forums

Objects marked as Compiled with Debug information


#1

In oracle 11g (11.0.1.7), if i compile an object with PLSQL_OPTIMIZE_LEVEL = 0 or 1, the object shows the green bug icon in the Schema Browser (see object_compiled_level_1.bmp attached), indicating that it is compiled with debug information. However, if i look in the data dictionary using the query below, the object is not compiled with debug info (PLSQL_DEBUG = FALSE)…

SELECT NAME, TYPE, PLSQL_OPTIMIZE_LEVEL, PLSQL_DEBUG
FROM user_plsql_object_settings
WHERE NAME = ‘PRODUCT_PKG’;

PRODUCT_PKG PACKAGE 1 FALSE
PRODUCT_PKG PACKAGE BODY 1 FALSE

If i compile the same object with PLSQL_OPTIMIZE_LEVEL = 2 (see object_compiled_level_2.bmp attached), then the green bug does not appear in the Schema Browser. Does any know why the PLSQL_OPTIMIZE_LEVEL impacts how TOAD displays the object in the Schema Browser?

Thanks,
Pete

object_compiled_level_1.bmp

object_compiled_level_2.bmp