How do we pass arrays from java to stored procedure in oracle

Question

How to pass an array of Strings from java to stored procedure ?

What is the IN parameter in the stored procedure to receive an array ?

What I am trying to do is, for all the values(Ids) present in the array, I fetch the rowfrom table X and insert it into table X_Audit

look at this post [stackoverflow.com/questions/8416815/pass-java-array-into-plsql/… [1]: stackoverflow.com/questions/8416815/pass-java-array-into-plsql/… — A.B.Cade
– A.B.Cade, Commented Dec 8, 2011 at 12:41
See asktom.oracle.com/pls/asktom/… for a working example with a table of int — Vincent Malgrat
– Vincent Malgrat, Commented Dec 8, 2011 at 13:10

Stephen ODonnell · Accepted Answer · 2011-12-09 14:11:02Z

2

I just spend the last few days working out a lot of JDBC related stuff, and one of my challenges was working out the answer to this exact question. I wrote up my solution on my blog: http://betteratoracle.com/posts/26-passing-arrays-between-java-and-oracle-procedures

You need to create some collection types on the database, and make the input parameters of the procedure have a type of the collections you created. See the article I posted above for full details and working code.

answered Dec 9, 2011 at 14:11

Stephen ODonnell

4,47619 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

How do we pass arrays from java to stored procedure in oracle

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related