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 Jul 17 '14 at 18:34
  • Not sure I understand the question. – ajeh Jul 17 '14 at 18:51
  • I mean that for the packages you can't expand, maybe the source code isn't available? – Vérace Jul 17 '14 at 18:52
  • Not the case. Both have PLENTY of source code and hundreds of procedures and functions. – ajeh Jul 17 '14 at 18:53

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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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