Subject About package variables
Author Dimitry Sibiryakov
Hello, All.

During round table on the conference there was a question about package variables and
what to do with them after ALTER PACKAGE.
What I think about it: if you consider declaration of package as a declaration of a
class and using of the package as using an object of this class, then all you need is to
decide what should be life time and visibility of this object.

a) Singleton object database object with unlimited life time;
b) Connection-wide object;
c) Transaction-wide object.

Then it is quite obvious what to do with variable values on ALTER: for a) they should
be preserved (unless the variable is dropped), for b) and c) it should depend on
transaction isolation level (as versioned metadata is a funny and unique thing), IMHO.