Executing a Stored Procedure using CallableStatement returns no ResultSet

Asked Nov 20 '14 at 06:09

Active Nov 20 '14 at 09:46

Viewed 1,537 times

I have the following SQL Server stored procedure:

CREATE PROCEDURE MyProc
AS
BEGIN
    SELECT * FROM MyTable
END

When I run this procedure using SSMS it returns a result. However, when I call this stored procedure from Java code using CallableStatement it does not returning any result and throws the exception

Statement did not return any ResultSet

Update 1:

My Java code is

String sql = "{ call MyProc };";
CallableStatement cs = con.prepareCall(sql);
ResultSet rs = cs.executeQuery();

edited Nov 20 '14 at 09:46

Gord Thompson

116,920
32
215
418

asked Nov 20 '14 at 06:09

Mohammad Ashfaq

1,333
2
14
38

3

Can you show me how your code looks? One more thing you add SET NOCOUNT ON; before select statement. – Paresh J Nov 20 '14 at 06:13
@Mo.Ashfaq can you try to change `String sql = "{ call MyProc };"; ` to `String sql = "{ call MyProc() };";` – Jens Nov 20 '14 at 06:22
@Jens tried this also String sql = "{ call MyProc() };"; but no result – Mohammad Ashfaq Nov 20 '14 at 07:21
@Mo.Ashfaq maybe you have to specify the out parameter. – Jens Nov 20 '14 at 07:30
1

Did you try the suggestion of Paresh? Otherwise use `execute` and `getMoreResults` and either get an update count or result set (based on the boolean return value). – Mark Rotteveel Nov 20 '14 at 07:56
1

Possible duplicate of [jdbc sql error: statement did not return a result set](http://stackoverflow.com/q/24428928/2144390) – Gord Thompson Nov 20 '14 at 09:40

Executing a Stored Procedure using CallableStatement returns no ResultSet

0 Answers0