Martijn van Oosterhout wrote: -- Start of PGP signed section. > On Wed, Aug 09, 2006 at 08:38:22AM +0100, Richard Huxton wrote: > > There are three separate issues we seem to be talking about. > > > > 1. Namespaces - visibility or otherwise of objects > > 2. Procedural state - something that looks like a shared variable > > 3. Packaging - installation/dependency handling > > Well, it would be nice to have some clarification about the expected > scope and lifetimes of these variables. If two different sessions > change the values, what's supposed to happen?
Right, I am confused whether these are session or schema-local variables. What does Oracle support? Looking at this: http://thinkoracle.blogspot.com/2005/10/oracle-packages.html it seems varaiable are per-session. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster