aspose file tools*
The moose likes JDBC and the fly likes Passing java arrays to PL/SQL and vice versa Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Passing java arrays to PL/SQL and vice versa" Watch "Passing java arrays to PL/SQL and vice versa" New topic
Author

Passing java arrays to PL/SQL and vice versa

Sarikaa Bhatnagar
Greenhorn

Joined: May 10, 2005
Posts: 26
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
Ranch Hand

Joined: Oct 11, 2000
Posts: 1124

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

http://tinyurl.com/8eldg

Good Luck,
Avi.
Sharma Ashutosh
Bartender

Joined: Apr 06, 2001
Posts: 346
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


Ashutosh Sharma
SCJP 1.2, SCEA 5, Brainbench certified J2EE Developer, Documentum Certified Professional
Blog : http://scea5-passingpart2and3.blogspot.com/
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Passing java arrays to PL/SQL and vice versa