Stored procedures are encapsulated by the class RWDBStoredProc. The DBTools.h++ access library for ODBC implementation of stored procedures is subject to many restrictions due to a combination of the ODBC SQL grammar and the capabilities of the underlying driver.
Not all ODBC drivers support stored procedures. Applications using drivers that don't support stored procedures will produce RWDBStoredProcs whose status is RWDBStatus::notSupported.
The DBTools.h++ access library for ODBC implements only a subset of RWDBStoredProc's functionality declared in the DBTools.h++ core. In particular, the two functions RWDBDatabase::createProcedure()and RWDBStoredProc::dropProcedure(), are not implemented and return a status of RWDBStatus::notSupported. It may be possible to use RWDBDatabase::executeSql() to create and drop procedures in a database specific manner.
RWDBStoredProc::text() is not supported and returns an empty RWCString.
Finally, although output and input/output parameters are supported, several ODBC drivers silently fail to update parameters, despite the capabilities of the underlying database. Users are cautioned to look carefully into the support that the underlying driver offers in this area before relying upon this feature.
The member function:
RWDBDatabase::storedProc(RWCString, RWDBConnection, RWDBSchema)
does not implement an instantiation of RWDBStoredProc that increases performance at this time. Currently, the member function is implemented identically to:
RWDBDatabase::storedProc(RWCString, RWDBConnection)
©Copyright 2000, Rogue Wave Software, Inc.
Contact Rogue Wave about documentation or support issues.