> 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.
Package variables are per-session.
Don't forget package initializers too...
Korry Douglas [EMAIL PROTECTED]