• Post Reply Bookmark Topic Watch Topic
  • New Topic

registerOutParameter  RSS feed

 
Sham Usha
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!