Re: How to return null/empty resultset from SP??
Posted by:
Ming Yeung
Date: December 12, 2005 07:28AM
The java code I have is... (very simple!!)
=================================
public ResultSet execProcedure(){
try{
rs = cs.executeQuery();
}catch(Exception exception){
exception.printStackTrace();
}
return rs;
}
=================================
DdManager DB = new DdManager();
DB.openConnection();
DB.prepareProcedure("{call adminCheckLogin(?,?)}");
DB.setString(1, username);
DB.setString(2, cryptedPassword);
ResultSet rs = DB.execProcedure();
if(rs.next()) {
...
} else ...
...
Thanks Pem!
Subject
Views
Written By
Posted
5189
December 11, 2005 08:50AM
2118
December 12, 2005 04:35AM
1973
December 12, 2005 07:23AM
Re: How to return null/empty resultset from SP??
1975
December 12, 2005 07:28AM
1843
December 12, 2005 05:06PM
1788
December 12, 2005 07:50PM
1701
December 13, 2005 04:42AM
3190
December 13, 2005 06:29AM
2446
December 13, 2005 07:39AM
1790
December 13, 2005 08:08AM
1667
December 13, 2005 03:18PM
1733
December 13, 2005 07:54PM
1769
December 15, 2005 06:04AM
1622
December 15, 2005 10:07AM
2040
January 15, 2006 11:50AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.