Win a copy of Testing JavaScript Applications this week in the HTML Pages with CSS and JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

How to Execute Stored Procedure?

 
Ranch Hand
Posts: 111
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have following SP
Create Procedure SP_Get_Status
(
@Status varchar(40) OUTPUT
)
as
Begin
Select @Status=Status from Status
End
----------------------------------------------
My Java Code is like THis
con=DriverManager.getConnection(url,"sa","");
CallableStatement cs=con.prepareCall("{call SP_Get_Status(?)}");
cs.registerOutParameter(1, java.sql.Types.VARCHAR);
cs.executeQuery();
-------------------------
Question 1.I get exception:
No ResultSet was produced
Where as this runs fine
Question 2:How to get a reslutset OBject out of this?
 
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
try:
ResultSet rs;
rs = cs.getResultSet();
while(rs.next()){
//do whatever you want to on the result set
}
    Bookmark Topic Watch Topic
  • New Topic