SourcePro : DB Access Module for Sybase User’s Guide : Technical Information : Stored Procedures : Instantiating an RWDBStoredProc Using Schema Data
Instantiating an RWDBStoredProc Using Schema Data
The member functions:
 
RWDBDatabase.storedProc(RWCString, RWDBSchema, RWDBColumn)
RWDBDatabase.storedProc(RWCString, RWDBConnection, RWDBSchema,
RWDBColumn)
increase the performance of stored procedures by eliminating the usual parameter fetch required for instantiations. The schema must include the name and type of each parameter in the stored procedure. Since all stored procedures in Sybase return an integer by default, the last parameter of type RWDBColumn that specifies the return value type is ignored. For example, the code in Creating a Stored Procedure uses the schema params to create the stored procedure; params could be used to instantiate an RWDBStoredProc. The paramType field is not necessary, but the name of each column /parameter in the schema must match the stored procedure parameter name exactly.