1. A package hosts a public variable.
2. A package body initializes the package variable.
3. package body is changed
4. package and package body are deployed.
5. oracle db only compiles the package body - package (header) is not compiled again (it didn't change).
=> querying package public variable reports the old conditions even though the package body and the initializer for the data had been changed.
Is this correct?
(I'll post an example next)
rgds,
Frank