Re: Array as parameter
Date: Wed, 1 Dec 2010 07:12:43 -0800 (PST)
Message-ID: <e4f08bfc-33e9-43d7-acd6-7622618809a8_at_n10g2000yqd.googlegroups.com>
On Nov 30, 11:45 am, jodleren <sonn..._at_hot.ee> wrote:
> Hi
>
> I posted some time ago about this, Mark D Powell answered, and I got a
> bit brighter, then other works, and I am back.
>
> I have the procedure to call:
>
> procedure VarastopaikkaSiirrot(ppSelite Vararasto_pack.vctable,
> Function VarastoPaikkaSiirrot2(ppJuoksu in pls_integer,
> ppPaikat in Vararasto_pack.intTable,
> ppPaikka in pls_integer,
> ppMuutos Vararasto_pack.floatTable,
> ppMuutos in number,
> ppTyyppi in char default 'S'
> ppTyyppi in char,
> ) is
> ppSelite in varchar2) return pls_integer is
>
> The point is, that I dont understand the ppSelite, or any parameter I
> need to send to it.
>
> There seems to be a number of "tables" in here, so what do I need to
> do?
> As of now I understand a bit, but know nothing
>
> Sonnich
Vararasto_pack.vctable would appear to be a packaged structure. You would need to declare and populate a collection of this type in your calling code.
I am pretty sure the example I posted had a pl/sql table (array) type definition, the declaration of the array using the type definition, and an example of a procedure that accepted the array as a parameter.
Since vctable is defined in a package you should be able to look at the package specification for the definition and you may find that the structure is used in some of the package body calls. If so you have examples that you can review.
Several of the other parameters also appear to be collections so you would need to refer back to their definitions and look for any existing code where these objects are populated and referenced in order to figure out proper use but floatTable and intTable would appear to just be lists of floating point or integer values so the code may not be as complex as it first appears.
HTH -- Mark D Powell -- Received on Wed Dec 01 2010 - 09:12:43 CST