passing an array from java and returning array from oracle procedure 1

[raji96]

Can someone give me an example of passing an array from java and sending back back an result in an array.I have to do some processing in the stored procedure based on the array and then return back a resultset as an array.


Thanks in advance.

--snebe

 

[LeonTang]

You can take a look at the example found in the class CallableStatement in the Java API. It should help you do whatever you want.

Regards,
Leon