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 accepting a stored procedure schema from the user while constructing
RWDBStoredProc objects. This eliminates the usual parameter fetch required for instantiations. The schema to be supplied to these methods can come from previously cached procedure schema, through
RWDBStoredProc::params(), or from user-created schema. The user-created schema must include the name and the type of each parameter in the stored procedure. When the type is unknown, the native type should be used. The native type, if set, is used first to avoid type mapping. The column should be supplied for any return value and must include a name and the datatype.