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.