jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes How to Execute Stored Procedure? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "How to Execute Stored Procedure?" Watch "How to Execute Stored Procedure?" New topic

How to Execute Stored Procedure?

Sanjay Deshpande
Ranch Hand

Joined: May 22, 2001
Posts: 111
I have following SP
Create Procedure SP_Get_Status
@Status varchar(40) OUTPUT
Select @Status=Status from Status
My Java Code is like THis
CallableStatement cs=con.prepareCall("{call SP_Get_Status(?)}");
cs.registerOutParameter(1, java.sql.Types.VARCHAR);
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?
A Sundaram

Joined: Jan 08, 2003
Posts: 7
ResultSet rs;
rs = cs.getResultSet();
//do whatever you want to on the result set
I agree. Here's the link: http://aspose.com/file-tools
subject: How to Execute Stored Procedure?
It's not a secret anymore!