Re: Passing arrays into stored procedures

I'm not sure about Oracle 7.3.4, but in Oracle 8, you can pass a PL/SQL array as a parameter without using a REF_CURSOR. Among the various ways of doing this is:

1. Create a package my_package with type declarations TYPE my_type IS TABLE OF VARCHAR2(30) INDEX BY NATURAL;
2. Declare your parameter as my_package.my_type. PROCEDURE my_procedure (my_parameter IN my_package.my_type) IS

Please let us know whether this is possible in Oracle 7.3.4.

Salaam

In article <38EBC856.2BFEADB6_at_lvvwd.com>,   Kyriakos Lambros <kyriakos.lambros_at_lvvwd.com> wrote:
> Hello everyone. I need to pass an array (i.e. all contents of a
 PL/SQL
> table) from Forms 5.0 to a stored procedure on an Oracle 7.3.4
> database. I want to try avoiding looping through the array on the
 forms
> side and calling the stored procedure in each iteration of the loop.
 I
> believe a REF_CURSOR will do this, but I believe it is only available
> Oracle 8 and higher. Please let me know if I am wrong about this
> assumption. Any help would be greatly appreciated.
>
> Thanks in advance!
>
> Kyriakos Lambros
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Apr 06 2000 - 00:00:00 CDT