Re: Passing arrays into stored procedures

Hi Salaam,

Thanks for the quick response. I already tried what you suggested and it does not work in Oracle 7.3.4. All the examples I have seen for ref cursor looks like you populate the cursor in the procedure that you called. This is impossible for me because the contents of the ref cursor are dependent on values the user selects in Forms. For instance, the user can select 1 or 10 values from a pick list. I then need to later execute a query where the WHERE clause looks like WHERE id IN (the values the user selected).

Thanks, Kyriakos

yitbsal_at_statcan.ca wrote:

> 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 - 12:27:25 CDT