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.
Oracle use packages dbms_pipe and dbms_alert for interprocess communication, not shared variables. For both packages exists emulation in orafunc on pgfoundry.
regards Pavel _________________________________________________________________ Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
