Fetching resultset from SP - mssql

I am calling an SP from MSSQL database.

The SP creates a temporary table and pushes data into that table. There is a select query on that temporary table at the end of the SP which retrieves records from that temporary table. The table gets deleted at the closure of the SP.

When I am calling this SP the rs.execute() is returning false. (I am supposed to get multiple resultsets)

Is this just because SP is retrieving data from the temp table.

I was successfull in calling the same SP (then it was having a series of select statements returning multiple resultsets)

please suggest.

rk.

SP - Stored Procedure

Message was edited by:

passion_for_java

[711 byte] By [passion_for_javaa] at [2007-11-26 17:44:38]