Stored Procedures
Many modern RDBMS implementations include a mechanism to enforce database policy through stored procedures. Database administrators may require users to do much of their data manipulation through stored procedures in order to restrict access to the underlying tables.
Class
RWDBStoredProc encapsulates database stored procedures. Class
RWDBStoredProc supports creating and deleting stored procedures, retrieving stored procedure definitions, executing stored procedures, and processing the results returned from these executions. Parameters may be passed to an
RWDBStoredProc prior to execution, and the values of output parameters may be retrieved. If a stored procedure can return multiple sets of results,
RWDBStoredProc can also access each result set in turn.
Unfortunately, the standards bodies say little about stored procedures, so stored procedure implementations vary widely among RDBMS vendors. If an
RWDBStoredProc feature is not supported by the underlying database, the DB Interface Module reports an
RWDBStatus::notSupported error.
NOTE: Be sure to read the stored procedures section of your Rogue Wave Access Module documentation to determine the full capabilities of your implementation.