How to pass an Array to the functions or Stored procedures

[amolik]

Hi all

Can we pass an array definition in the parameters list of a function or procedures. For e.g.

Create or replace function tem_1 ()
begin
for i in .. loop

end loop;

This is required for Java programmers who are calling different procedures where the no. of parameters are fixed from Java programs, but now they want that the list of parameters should not be fixed and they should be able to pass as many parameters with datatypes. I havent found any such facility in oracle. Can you all help me out in this

Thanks in Advance

Amol

[pando]

yes we can, go to asktom.oracle.com and serach for array procedure