Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

registerOutParameter

 
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic