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
Author

how to pass arrayList to calling Procedure

dilip sarode
Greenhorn

Joined: Jan 11, 2010
Posts: 1
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

Joined: Aug 03, 2008
Posts: 9280
    
  17

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
Sheriff

Joined: Oct 13, 2005
Posts: 36599
    
  16
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: http://aspose.com/file-tools
 
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