Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes 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: 9578
33
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
Sheriff
Posts: 51368
87
  • 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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic