On Wed, Aug 09, 2006 at 10:55:30AM -0400, Bruce Momjian wrote: > 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.
Yes, everything in PLSQL is per-session. I don't know of any way to share data between sessions in PLSQL short of using a (real) table. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
