posted 18 years ago
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