Problem: Debugging a database stored procedure before developing a database service.
Solution: See the Database Development Troubleshooting section in this online bookshelf.
Problem: Errors encountered when discovering results sets for ASE stored procedures created in Sybase WorkSpace
Solution: Go to Windows|Preference|Sybase, Inc|Services|Database Service Editor, uncheck the option "Rollback after 'Discovering' result sets for an operation". Also ensure that the checkbox for Autocommit is selected on the Database service editor, Operation Properties panel.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com