This week's book giveaway is in the HTML/CSS/JavaScript forum.
We're giving away four copies of Practical SVG and have Chris Coyier on-line!
See this thread for details.
Win a copy of Practical SVG this week in the HTML/CSS/JavaScript 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
 
This will take every ounce of my mental strength! All for a tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!