HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

What does a green icon mean and why do the package bodies not expand when they have it?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
expandwhyiconthepackagewhatmeanbodiesdoeswhen

Problem

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?

Solution

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.

Context

StackExchange Database Administrators Q#71774, answer score: 7

Revisions (0)

No revisions yet.