Name: krT82822 Date: 08/10/99


The problem I'm having is that I'm trying to call a stored procedure via JDBC. I make the call in my code like this:

(Assume con is valid connection to the DB)
===
CallableStatement proc = con.prepareCall("execute spMasterImport");
ResultSet rs = proc.executeQuery();
===
The stored proc returns multiple results (from multiple Select stmts), but i don't care about the results.

What I'm seeing is that the stored proc doesn't execute, nor does it throw an exception.

If I run the stored proc in SQL Advantage (for Sybase), it runs fine.

I'm using Sybase v11.5.2 and I'm using the native ODBC drivers.

- Mike

------------------

7/30/99 kevin.ryan@eng -- may be related to bug # 4233976 (each ResultsSet not getting closed). Problems with CallableStatement seem to have
occurred more with the ODBC Bridge, not with native drivers. Filing new bug.


---------------------
8/10/99 kevin.ryan@eng -- RE-submitting bug, since Bugs-By-Mail was toast on and off during the past ten days or so.



(Review ID: 88335)
======================================================================