Re: Arrays as Parameters

From: Grinberg L. <leon_at_grant.kharkov.ua>
Date: Sat, 3 Oct 1998 12:46:09 +0300
Message-ID: <6v4r9a$alr@grant.grant.UUCP>

Rishaal Jadoo wrote in message <6v065n$id1_at_goliath.iscorltd.co.za>...
>Hi,
>
>I would like to pass arrays between PL/SQL stored procedures.
..
>Type
>MyArr .... ;
>Parameter_Array My Arr;
>
>
>Call_Receiving_Proc(Parameter_Array);
>

Parameter_Array in your calling procedure has similar type, but not the same that in receiving procedure. You must declare type MyArr in package specification and both arrays must be declared exactly with it. For example.

PACKAGE ex1 IS
Type MyArr .... ;
.........
END; Then in receiving stored procedures you must declare parameter

PROCEDURE Call_Receiving_Proc
(Receiving_Array ex1.MyArr
) IS
BEGIN
...
END; And in calling procedure

DECLARE
...
Sending_Array ex1.MyArr;
...
BEGIN
Call_Receiving_Proc(Sending_Array);
...
END; Names of "sending" and "receiving" arrays may be different or not - it doesn't matter. Received on Sat Oct 03 1998 - 04:46:09 CDT