How to pass an array to a sql stored procedure from java program

Question

I have to send an array to a stored procedure as a parameter from java program. how can we do that. please help me in this

What database? Arrays and stored procedures are a tricky topic when it comes to handling them with JDBC. Also, are you just using plain JDBC, or some sort of abstraction, such as JPA? — Lukas Eder
– Lukas Eder, Commented Jul 18, 2011 at 13:05
Which data base do you use. For PL/SQL I think you can find an answer here asktom.oracle.com/pls/asktom/… — Fedor Skrynnikov
– Fedor Skrynnikov, Commented Jul 18, 2011 at 13:06
And please add the signature of the stored procedure as well. — Codo
– Codo, Commented Jul 18, 2011 at 13:06

Amit · Accepted Answer · 2011-07-18 13:09:57Z

1

This is a vendor centric implementation and so would be different for different databases. For Oracle you need to use ArrayDescriptor class of oracle.sql package. Follow the link below for a sutable answer discussed on AskTom site: http://asktom.oracle.com/pls/asktom/f?p=100:11:2906896739396193::::P11_QUESTION_ID:712625135727

answered Jul 18, 2011 at 13:09

Amit

4756 silver badges12 bronze badges

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

Comments

Lukas Eder · Accepted Answer · 2011-07-18 13:10:53Z

1

That depends on your database. Some databases (for example Postgres, HSQLDB) and their JDBC drivers support anonymous arrays, which you can set with

Object[] array = // ...
pstmt.setObject(index, array);

Oracle is more complex as it needs a typed object.

answered Jul 18, 2011 at 13:10

Lukas Eder

223k138 gold badges729 silver badges1.6k bronze badges