• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Passing java arrays to PL/SQL and vice versa

 
Sarikaa Bhatnagar
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sarika,
Have a look at this (very) recent discussion (in this forum):

http://tinyurl.com/8eldg

Good Luck,
Avi.
 
Sharma Ashutosh
Bartender
Posts: 346
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic