Announcement Announcement Module
No announcement yet.
Sybase stored procedure resultset problem Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • Sybase stored procedure resultset problem

    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.