Re: Pass arrays into stored procedures - oracle 8i

Look up ORACLE "collections" in PL/SQL developer guide. There are 3 collection types : index-by table (formerly known as pl/sql table), nested table and varray. The size of vaaray is fixed. Index-by table should be the one you are looking for.

jonna311_at_yahoo.com (jpl) wrote in message news:<bd19caaa.0208130134.9de38b6_at_posting.google.com>...
> Hi
> I am trying to write a stored procedure where i need to pass in an
> array of userids. This array needs be of dynamic size. Can we declare
> an array of variant size in a stored procedure ? Can anyone please
> tell me how to do it and how the performance will be ?
>
> Thanks in advance
Received on Tue Aug 13 2002 - 18:10:32 CEST