Re: PL/SQL Arrays

On Wed, 19 Nov 2003 19:18:47 GMT, Richard Kuhler <noone_at_nowhere.com> wrote:
>As soon as I hit send, I realized my solution of course points at
>another solution if you're willing to have a public global variable ...
>
>empty_numarray numarray;
>procedure wrap (p_numbers in numarray := empty_numarray);
>
>I'm not sure I like this solution since anybody could screw with that
>variable and change the default behavior of that procedure in their
>session. However, that might actually be desirable in some situations.

I ran into the same problem, with the same solution. To avoid problems from other code changing the variable, you could declare empty_numarray as a constant within the package.

John

--
Photo gallery: http://www.pbase.com/john_russell/