Am having problems returning a resultset from a Sybase stored procedure when the results from a query are inserted into either a fixed table or a temp table in the proc prior to return.

Am calling the proc from a Spring Controller via a Facade. AM using SqlReturnResultSet and RowMapper to retrieve data and have checked Transaction environment.

Results are returned when a call is made directly from a table within the proc.

When the same Spring Facade is called from a Struts Contoller the scenario above which does nor return results from Sprong works fine.