<blockquote type="CITE"><pre>
<font color="#000000">> Well, it would be nice to have some clarification about the expected</font>
<font color="#000000">> scope and lifetimes of these variables. If two different sessions</font>
<font color="#000000">> change the values, what's supposed to happen?</font>
<font color="#000000">Right, I am confused whether these are session or schema-local</font>
<font color="#000000">variables. What does Oracle support? Looking at this:</font>
<font color="#000000"> <a
href="http://thinkoracle.blogspot.com/2005/10/oracle-packages.html">http://thinkoracle.blogspot.com/2005/10/oracle-packages.html</a></font>
<font color="#000000">it seems varaiable are per-session.</font>
</pre></blockquote><br /> Package variables are per-session. <br /><br /> Don't forget package initializers too...<br
/><tablecellpadding="0" cellspacing="0" width="100%"><tr><td><br /><br /> --<br /> Korry Douglas <a
href="mailto:korryd@enterprisedb.com">korryd@enterprisedb.com</a><br/> EnterpriseDB <a
href="http://www.enterprisedb.com">http://www.enterprisedb.com</a></td></tr></table>
