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. The column must include the name and the datatype of the return value, if any. 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 along with an
RWDBColumn whose datatype is
RWDBValue::Int.