Persistence in Oracle Packages

[Quoted] I've got a couple of stored procedures (proc a and proc b) that I want to place in a single package. I want to call proc a, which will set some persistent variable x within the package, and exit. Then, later on, I want to call proc b, and I want proc b to have access to variable x. In other words, I want the variable x to be persistent while the package is in memory. Of course, anyone else who calls this package will have their own copy of the package.

Is this possible? How is it done? This means there must be some sort of constructor type method, right?

Thanks,
Salaam Yitbarek

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Jan 18 1999 - 22:37:00 CET