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

On Nov 30, 11:45*am, jodleren <sonn... (AT) hot (DOT) ee> wrote:
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 --

On Dec 1, 5:12*pm, Mark D Powell <Mark.Powe... (AT) hp (DOT) com> wrote:
But where do I find that declaration?
I have Database Explorer and ToadFree, and I have been looking for
these declaraitons.

How do I find the package?

You are probably right, but for me new to this it is not so.
I have a feeling that I have walked in the wrong direction, as I have
not found some solution yet

Sonnich

On Dec 1, 11:47*am, jodleren <sonn... (AT) hot (DOT) ee> wrote:
Packages are stored in the database and the source (assuming it is not
wrapped) is available in dba_source to the owner or a DBA privileged
user (or select any catalog) etc .... Or you can use dbms_metadata to
generate the source.

There should also be some kind of source code management system in use
at your company/customer.

If the package is part of a vendor product and it is wrapped then you
are out of luck unless you obtain one of the available third party de-
wrapping products available. That or the Vendor documentation
contains information on these objects.

HTH -- Mark D Powell --