Arrays as Parameters

From: Rishaal Jadoo <rischalj_at_dp.new.iscorltd.co.za>
Date: Thu, 1 Oct 1998 17:13:11 +0200
Message-ID: <6v065n$id1@goliath.iscorltd.co.za>

Hi,

I would like to pass arrays between PL/SQL stored procedures.

The receiving package has been setup and compiles fine, expecting an array as a parameter.

The calling stored procedure, however, refuses to compile saying that there is an incorrect type or number of arguments in the call.

What is the syntax for the call ... at the moment, I just use the name of the array declared in the the calling stored procedure i.e. In the calling procedure :

Type
MyArr .... ;
Parameter_Array My Arr;

Call_Receiving_Proc(Parameter_Array);

The sending and receiving arrays are of the same type.

Thanks. Received on Thu Oct 01 1998 - 10:13:11 CDT