Passing java arrays to PL/SQL and vice versa

[Sarikaa Bhatnagar]

Hi,

How can i pass java array to PL/SQL ( stored procedures oracle) and return an array from PL/SQL and receive in java.

I am using oracle 9i.

Thanks,
Sarika.

[Avi Abrami]

Sarika,
Have a look at this (very) recent discussion (in this forum):

http://tinyurl.com/8eldg

Good Luck,
Avi.

[Sharma Ashutosh]

u hav to first create a type in PL/SQL via SQL*Plus like this:
create or replace type NUM_ARRAY as table of number;
then hav to use it in the function/proc like this:
create or replace function getStack(bbid_array in num_array)
Morever visit this URL
web page