Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

how to pass arrayList to calling Procedure

 
dilip sarode
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ,
i am using

CallableStatement cs = conn.prepareCall("{call updateSallary(?,?,?)}");
cs.registerOutParameter(1,Types.INTEGER);
cs.registerOutParameter(2,Types.INTEGER);
cs.registerOutParameter(3,Types.VARCHAR);

and i have to pass arrayList to the 2,Types.INTEGER.

how to pass it. and then get from procedure


Thanks a lot.
 
Ankit Garg
Sheriff
Posts: 9597
36
Android Google Web Toolkit Hibernate IntelliJ IDE Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Dilip, welcome to javaranch.

This question has nothing to do with Servlets, so I'll move it to the more appropriate forum for you...
 
Campbell Ritchie
Marshal
Posts: 53096
124
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Do you mean you have a List<Integer> which you want to get 3 elements out of, or are you passing a List<Integer> to the no 2 parameter?
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!