Re: Passing arrays into stored procedures

From: Andrea Cannaos <andrea.cannaos_at_deagostini.it>
Date: 2000/04/07
Message-ID: <38EDC792.7D3A360@deagostini.it>#1/1

Kyriakos Lambros 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

You can define a PL/SQL table as parameter of your procedure .... Received on Fri Apr 07 2000 - 00:00:00 CDT