Stored Procedures
The DB Access Module for Sybase includes full support for Adaptive Server stored procedures, including support for creating and dropping stored procedures, retrieving stored procedure text and parameter definitions, executing stored procedures, processing multiple result sets, processing output parameters, and processing return values.
Stored procedures are encapsulated by the class
RWDBStoredProc. The implementation uses the Client-Library RPC commands rather than an execute language statement, which allow parameters to be passed as native datatypes instead of character data within the text of the language command. The Client-Library documentation indicates that using RPC commands is the most efficient way to handle stored procedures.