Re: Passing arrays into stored procedures
From: Andrea Cannaos <andrea.cannaos_at_deagostini.it>
Date: Fri, 07 Apr 2000 13:33:38 +0200
Message-ID: <38EDC792.7D3A360_at_deagostini.it>
Date: Fri, 07 Apr 2000 13:33:38 +0200
Message-ID: <38EDC792.7D3A360_at_deagostini.it>
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 - 13:33:38 CEST