SourcePro : DB Access Module for MySQL 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 instantiation. The schema must include the RWDBColumn::ParamType of each parameter in the stored procedure.
For example, the code in Creating Stored Procedures uses the schema params to create the stored procedure; params could be used to instantiate an RWDBStoredProc. Note that the RWDBColumn parameter for specifying the return value is not used by the DB Access Module for MySQL.