Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes how to pass arrayList to calling Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to pass arrayList to calling Procedure " Watch "how to pass arrayList to calling Procedure " New topic

how to pass arrayList to calling Procedure

dilip sarode

Joined: Jan 11, 2010
Posts: 1
Hi ,
i am using

CallableStatement cs = conn.prepareCall("{call updateSallary(?,?,?)}");

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

Joined: Aug 03, 2008
Posts: 9291

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...

SCJP 6 | SCWCD 5 | Javaranch SCJP FAQ | SCWCD Links
Campbell Ritchie

Joined: Oct 13, 2005
Posts: 37936
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?
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: how to pass arrayList to calling Procedure
Similar Threads
How to create Oracle stored procedure and return ResultSet as OUT param...?
help:java.sql.SQLException: ORA-06550
retrieving value from SQL Server 2000 stored procedure
Call PLSQL procedure from Java, parameter error
Retrieiving OUT parameters & return value from a Sybase Stored Procedure