Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL Arrays

Re: PL/SQL Arrays

From: Richard Kuhler <noone_at_nowhere.com>
Date: Fri, 21 Nov 2003 18:25:33 GMT
Message-ID: <xMsvb.692$t01.242@twister.socal.rr.com>


John Russell wrote:

> 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.

I don't see how this will work. When you try to make it a constant, it's going to require an initialization. That puts us right back to the original problem as far as I can see. Namely, how do you write a value declaration for an index by array?

--
Richard Kuhler
Received on Fri Nov 21 2003 - 12:25:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US