CB, There is sample code available from the OTN Web site.
Good Luck, Avi.
Joined: Feb 09, 2005
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?