• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Stored procdure return multi dimensional array?

 
chelakkad ben
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
How do you pass a muti dimensional array from an oracle fn/procedure to java ?
Can someone help me with an example?
rgds
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
CB,
There is sample code available from the OTN Web site.

Good Luck,
Avi.
 
chelakkad ben
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello
Thanks for the reply, Avi. But can u pl point out the link? I was not able to find what u mentioned at the site.
The problem is , i have a procedure that should query table A based on an id , sent as IN parameter. For each record (a_code) obtained ,table B is queried to obtain Seq_no and L_code .However if no record is found in table B, then table C is queried for that a_code to obtain Seq_no and L_code.
The results are put in a 2D arrary and sent back to calling Java code.
So how do you send a mutidimentional array back from the fn? and the java code to get the data in the array?

Is there a better method? Can we do using SQL?

thanks
rgds
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
CB,
Start here:

http://www.oracle.com/technology/tech/java/sqlj_jdbc/index.html

Good Luck,
Avi.
 
chelakkad ben
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Avi
Thanks once again.
rgds
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic