Re: passing array of numbers to stored procedure

1. yes, but i believe that it only works from one stored procedure to the other i am not sure if you can make it work with java and a stored procedure
2. it works like this, but there are different ways to do it (with varray for example) type my_array_type is table of number; my_array my_array_type;
3. no i don't think so, except with the Stored Procedure array, i showed above

kazelot_at_thenut.eti.pg.gda.pl wrote:

> I'm using Oracle 8.1.6.
>
> I connect to it through JDBC. I would like to have a stored procedure
> which would take array as a parameter. And then use the array to do
> something like this:
>
> select * from table1
> where table1.id in myArray;
>
> My questions:
> 1. How can I pass array to stored procedure?
> 2. How to create an array in the body of stored procedure?
> 3. Is select like above legal?
>
> Tank you,
> kazelot
Received on Tue Jul 03 2001 - 14:40:05 CDT