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

Community · Accepted Answer · 2017-05-23 12:19:29Z

1

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

CommunityBot

11 silver badge

answered Sep 9, 2016 at 17:58

Richard Campbell

3,63126 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

How to setArray without using ArrayDescriptor class