Level 1 API Functions (ODBC Driver for Oracle)

Important

This feature will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Instead, use the ODBC driver provided by Oracle.

Functions at this level provide Core interface conformance plus additional functionality such as transaction support.

API function Notes
SQLColumns Creates a result set for a table, which is the column list for the specified table or tables. When you request columns for a PUBLIC synonym, you must have set the SYNONYMCOLUMNS connection attribute and specified an empty string as the szTableOwner argument. When returning columns for PUBLIC synonyms, the driver sets the TABLE NAME column to an empty string. The result set contains an additional column, ORDINAL POSITION, at the end of each row. This value is the ordinal position of the column in the table.
SQLDriverConnect Connects to an existing data source. For details, see Connection String Format and Attributes.
SQLGetConnectOption Returns the current setting of a connection option. This function is partially supported. The driver supports all values for the fOption argument but does not support some vParam values for the fOption argument SQL_TXN_ISOLATION. For more information, see Connect Options.
SQLGetData Retrieves the value of a single field in the current record of the given result set.
SQLGetFunctions Returns TRUE for all supported functions. Implemented by the Driver Manager.
SQLGetInfo Returns information, including SQLHDBC, SQLUSMALLINT, SQLPOINTER, SQLSMALLINT, and SQLSMALLINT *, about the ODBC Driver for Oracle and data source associated with a connection handle, hdbc.
SQLGetStmtOption Returns the current setting of a statement option. For more information, see Statement Options.
SQLGetTypeInfo Returns information about the data types supported by a data source. The driver returns the information in a SQL result set.
SQLParamData Used in conjunction with SQLPutData to specify parameter data at statement execution time.
SQLPutData Allows an application to send data for a parameter or column to the driver at statement execution time.
SQLSetConnectOption Provides access to options that govern aspects of the connection. This function is partially supported: The driver supports all values for the fOption argument but does not support some vParam values for the fOption argument SQL_TXN_ISOLATION. For more information, see Connect Options.
SQLSetStmtOption Sets options related to a statement handle, hstmt. For more information, see Statement Options.
SQLSpecialColumns Retrieves the optimal set of columns that uniquely identifies a row in the table.
SQLStatistics Retrieves a list of statistics about a single table and the indexes, or tag names, associated with the table. The driver returns the information as a result set.
SQLTables Returns the list of table names specified by the parameter in the SQLTables statement. If no parameter is specified, returns the table names stored in the current data source. The driver returns the information as a result set.

Enumeration type calls will not receive a result set entry for remote views or local parameterized views. However, a call to SQLTables with a unique table name specifier will find a match for such a view, if present, with that name; this allows the API to check for name conflicts prior to creation of a new table.

PUBLIC synonyms are returned with a TABLE_OWNER value of "".

VIEWS owned by SYS or SYSTEM are identified as SYSTEM VIEW.