Two Laptop Bag*
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 Java 8 in Action this week in the Java 8 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: 9280

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: 36599
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?
I agree. Here's the link:
subject: how to pass arrayList to calling Procedure
Similar Threads
retrieving value from SQL Server 2000 stored procedure
How to create Oracle stored procedure and return ResultSet as OUT param...?
Call PLSQL procedure from Java, parameter error
help:java.sql.SQLException: ORA-06550
Retrieiving OUT parameters & return value from a Sybase Stored Procedure