Re: Passing arrays into stored procedures
Date: Thu, 06 Apr 2000 16:06:03 GMT
Message-ID: <8cickt$1vs$1_at_nnrp1.deja.com>
[Quoted] 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:
- Create a package my_package with type declarations TYPE my_type IS TABLE OF VARCHAR2(30) INDEX BY NATURAL;
- 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 - 18:06:03 CEST