How can we pass array to IN param and retrieve array from OUT param using java sql

Question

Pass array to IN param and getting array from OUT param using java sql . Without using ArrayDescriptor class.

I had a stored procedure like

create or replace Proc_name(
    vargs IN paramarray1,
    resp  OUT paramarray2)
..............
......

vargs like 5 input values and res will be in 3 out parameters

Answer 1

You need to create a java.sql.CallableStatement around your stored procedure, and then use the setArray and getArray methods.

Here's an example: Fetch pl/sql array return values in java