Executing a stored procedure returns false

[Srikkanth Mohanasundaram]

Hello all,

I'm using the following code to call a stored procedure and use the multiple result sets returned by the procedure.

 
cstmt = conn.prepareCall("{ call "+ "<<proc name>>"+ " (?)}");
cstmt.setString(1, param);
boolean ind=cstmt.execute();
System.out.println(ind);
   

The console prints false and i am unable to get the results.
The procedure as mentioned returns mutiple resultsets and I'm using Microsoft SQL server 2005. I did a call to this procedure from SQL editor and it works fine. Can someone let me know on what i am doing wrong here?

Thanks,
Srikkanth

[Jeanne Boyarsky]

Srikkanth,
Does the stored procedure do any insert/update/deletes? If so, the stored procedure may be returning the # rows changed rather than the resultsets.

[Srikkanth Mohanasundaram]

Yes you are right. It does some delete of temporary tables. So how would i get the resultsets , is it not possible?

Thanks for your help,
Srikkanth

[Jeanne Boyarsky]

Srikkanth Mohanasundaram wrote:Yes you are right. It does some delete of temporary tables. So how would i get the resultsets , is it not possible?

I would think it is possible. How to do so varies by database though. Conceptually, the stored procedure accumulates the result sets and returns them.