CODBCStmt.GetProceduresmethod
Returns the list of procedure names stored in a specific data source.
Syntax
FUNCTION GetProcedures (BYREF wszCatalogName AS WSTRING, BYVAL CatalogNameLength AS SQLSMALLINT, BYREF wszSchemaName AS WSTRING, BYVAL SchemaNameLength AS SQLSMALLINT, BYREF wszProcName AS WSTRING, BYVAL ProcNameLength AS SQLSMALLINT) AS SQLRETURN
Parameters
| Name | Description | |
|---|---|---|
wszCatalogName | Procedure catalog. If a driver supports catalogs for some tables but not for others, such as when the driver retrieves data from different DBMSs, an empty string ("") denotes those tables that do not have catalogs. wszCatalogName cannot contain a string search pattern. | |
CatalogNameLength | Length of wszCatalogName. | |
wszSchemaName | String search pattern for procedure schema names. If a driver supports schemas for some procedures but not for others, such as when the driver retrieves data from different DBMSs, an empty string ("") denotes those procedures that do not have schemas. | |
SchemaNameLength | Length of wszSchemaName. | |
wszProcName | String search pattern for procedure names. | |
ProcNameLength | Length of wszProcName. |
Return value
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.
Description
Returns the list of procedure names stored in a specific data source. Procedure is a generic term used to describe an executable object, or a named entity that can be invoked using input and output parameters.
Reference
- Include file
CODBCStmt.inc - Defined in AfxNova/COdbcStmt.inc:2027
- Documented in Databases/ODBC Classes/CODBCStmt Class.md
- Topic: CODBCStmt Class