aspose file tools*
The moose likes Java in General and the fly likes registerOutParameter Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "registerOutParameter" Watch "registerOutParameter" New topic
Author

registerOutParameter

Sham Usha
Greenhorn

Joined: Jul 22, 2001
Posts: 11
Hi..
When Stored Procedure returns a value(VARCHAR or NUMBER) ,In the javabean we used as follows
CallableStatement callstmt= null;
int NoRec;
callstmt=conn.prepareCall("{call PKG_NAME.PROCEDURE_NAME(?,'" +VARIABEL+ "')}");
callstmt.registerOutParameter(1, java.sql.Types.INTEGER);
callstmt.execute();
NoRec=callstmt.getInt(1);
callstmt.close();
My prob. is I used Stored Procedure and its return an array type
then how I register it in the bean and what is getxxx method?
OR else if Stored Procedure returns multiple records how it get into javabean?
Thanks in advance
Usha
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: registerOutParameter
 
Similar Threads
Return more recods from stored procedure
resultset and .first() query
how do i get this boolean
Stored Procedures
executeUpdate() returning unexpected results