I have some numbers generated in a sql package. I need these numbers to be held by some kind of object that is available to the entire package. The package makes calls to other packages, so my attempts to use a global variable that is a type table of number does not work because that gets reset when calls are made to other packages (at least I assume that is how they are getting reset).
Is my only option to simply create a one column table that I delete from every time I am done with the numbers? Or is there something that will hold this data for me like I need it to other than a table?
True wisdom is in knowing you know nothing - Socrates