accessing resultset as well as return parameter
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   hemanth_kumar
Posted On:   Thursday, January 2, 2003 11:44 AM

			I am calling stored procedure which is returning result set and as well as return parameter.
			
I want to access both resultset and returnparamer.
I am using callable statement.
I am resgistering the variable using cs.registeroutputparameter() and accessing using callblestatement.getint().
when i use like this i couldn't get resultset eventhough its returning resultset.if I comment out that cs.getint()then i am able to access the resultset.
Could anybody tell me how to access both resultset and return parametre.

Thanks in advance

Hemanth

Re: accessing resultset as well as return parameter

Posted By:   Gautam_Marwaha  
Posted On:   Thursday, January 2, 2003 10:34 PM

Use CallableStatement to execute the SP - callStmt.execute(). check using getUpdateCount() method if any resultset(s) are given back from the SP. Use ResultSet rs = callStmt.getResultSet() to get the result set. You shd also be able to get output parameters the usual way
About | Sitemap | Contact