How to return rowcount using Stored procedures through CallableSt atement?

[Gong Anna]

Hi,
I am using following code to execute my stored procedure SQL_EXEC, which
takes the qry string as a parammeter and execute it. How do I get a return
of rowcount number when doing insert, delete and update?

                        try{
                                        String spCall="{call SQL_EXEC(?)}";
                                        CallableStatement
stmt=db.prepareCall(spCall);
                                        stmt.setString(1,qryDel);
                                        n=stmt.executeUpdate();
                                }
                        catch (Exception e) {
                                        out.print("Error Calling SP,
Exception " + e);
                                }
I cannot use n here because it's always equals to 0.
Any help will be greatly appreciated.
Anna

===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html