In SQLDeveloper 4 some 10g PL/SQL packages have a regular crate while others have a green dot.

Those with the green dot do not expand their bodies (might be just a coincidence). What is the difference between the packages with and w/o a green dot and why do some packages not expand their bodies?

enter image description here

  • No source code?
    – Vérace
    Commented Jul 17, 2014 at 18:34
  • Not sure I understand the question.
    – ajeh
    Commented Jul 17, 2014 at 18:51
  • I mean that for the packages you can't expand, maybe the source code isn't available?
    – Vérace
    Commented Jul 17, 2014 at 18:52
  • Not the case. Both have PLENTY of source code and hundreds of procedures and functions.
    – ajeh
    Commented Jul 17, 2014 at 18:53

1 Answer 1


The green bug you're seeing (look closely) means the package have been compiled with DEBUG option. It is also seen on bare procedures and functions. It is a coincidence they don't expand - maybe a bug (duh) in SQLdeveloper :) On mine, these expand without problem.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.