How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
Contents → Technology 1.3 Oracle Database Gateway for ODBC 1.4 Oracle Database Gateway for ODBC Architecture 1.4.1 … Machine 1.5 ODBC Connectivity Requirements 2 Oracle Database Gateway for ODBC Features and Restrictions … Date Arithmetic A Data Type Conversion A.1 Mapping ODBC Data Types to Oracle Data Types B
Creating an ODBC Data Source → You must create an ODBC data source to connect to the SQL Server. To do this, you must set up a … System Data Source Name (DSN): Select Start, Control Panel, Administrative Tools, Data Sources (ODBC … ). This opens the ODBC Data Source Administrator dialog box. Navigate to the System DSN tab and click
5.4.2 Using Oracle ODBC Driver → The ODBC Driver Manager distributed with ODBC 3.0 is a Resource Dispenser that supports connection … pooling. Oracle ODBC Driver release 11.1 integrates with the ODBC 3.0 Driver Manager by supporting … the SQLSetConnectAttr(...,..., SQL_ATTR_ENLIST_IN_DTC) call to enlist or de-enlist the ODBC
Oracle Compliance with SQL/CLI:2003 → The Oracle ODBC driver conforms to SQL/CLI:2003.
5.4.3 Using Microsoft Oracle ODBC Driver → As an alternative to the Oracle ODBC driver, you can use the Microsoft Oracle ODBC Driver. You … benefits of the Oracle ODBC driver, API support for integration, or Oracle client support services … . After enabling the Microsoft Oracle ODBC Driver, perform these additional steps to configure the … Microsoft Oracle
Open Database Connectivity → Open database co nnectivity (ODBC), is a database access protocol that lets you connect to a … database and then prepare and run SQL statements against the database. In conjunction with an ODBC driver … . Because ODBC is a widely accepted standard API, applications can be written to comply to the ODBC standard
5.4 ODBC Integration with Microsoft Transaction Server Overview → This section describes how to use Oracle ODBC Driver with Microsoft Transaction Server and a Oracle … Database. No changes to OCI code are necessary for ODBC to operate successfully.
Generic Connectivity → Generic Connectivi ty is a generic solution that uses an ODBC or OLEDB driver to access any ODBC or … as ODBC and OLEDB. Generic connectivity makes it possible to access low-end data stores, such as
Generic Connectivity → Heterogeneous Services ODBC agent or a Heterogeneous Services OLE DB agent. Both are included with … your Oracle product as a standard feature. Any data source compatible with the ODBC or OLE DB standards … ODBC or OLE DB driver that can interface with the agent. However, some data access features are only available with transparent
1.5 ODBC Connectivity Requirements → To use Oracle Database Gateway for ODBC, you must have an ODBC driver installed on the same machine … as the gateway. The ODBC driver manager and driver must meet the following requirements: The … following ODBC catalog functions must work inside a transaction: SQLColumns SQLForeignKeys SQLGetFunctions … On Windows:
ODBC Datatype Oracle Datatype → SQL_WCHAR NCHAR SQL_WVARCHAR NVARCHAR2 SQL_WLONGVARCHAR NCLOB According to ODBC specifications
ODBC Unicode Datatypes → In ODBC Unicode applications, use SQLWCHAR to store Unicode data. All standard Windows Unicode … ); Microsoft's ODBC 3.5 specification defines three Unicode datatype identifiers for the SQL_C_WCHAR … the ODBC Unicode datatypes for the server against SQL NCHAR datatypes. Table 7-9 Server ODBC Unicode Datatype Mapping
18 Oracle ODBC Driver → The Oracle ODBC Driver Readme file is located at: $ORACLE_HOME/odbc/html/ODBCRelnotesUS.htm
11.6.5 Multiple ODBC Data Sources Example: Accessing ODBC Data → are created, you can verify the connection to the new ODBC data sources, as in the following: SQL
Multiple ODBC Data Sources Example: Accessing ODBC Data → are created, you can verify the connection to the new ODBC data sources, as in the following: SQL
E Using Oracle ODBC Driver → Note: Oracle ODBC Driver is supported only on the Linux x86 and Oracle Solaris on SPARC platforms … . This appendix provides information related to using Oracle ODBC Driver. It contains the following … Connection String for the SQLDriverConnect Function Reducing Lock Timeout in a Program Linking ODBC
E.6 Linking ODBC Applications → When you link the program, you must link it with the Driver Manager library, libodbc.so.
2.2.1 COMMIT or ROLLBACK in PL/SQL Cursor Loops Closes Open Cursors → Any COMMIT or ROLLBACK issued in a PL/SQL cursor loop closes all open cursors, which can result in the following error: ORA-1002: fetch out of sequence To prevent this error, move the COMMIT or ROLLBACK statement outside the cursor loop.
D.3.1 HS_DB_DOMAIN → Property Description Default value WORLD Range of values 1 to 199 characters Specifies a unique network sub-address for a non-Oracle system. The HS_DB_DOMAIN initialization parameter is similar to the DB_DOMAIN initialization parameter, described in the Oracle Database Reference. The HS_DB_DOMAIN initialization parameter is required if you use the Oracle Names server. The HS_DB_NAME and HS_DB_DOMAIN
1.4 Oracle Database Gateway for ODBC Architecture → To access the non-Oracle data store using Oracle Database Gateway for ODBC, the gateway works with … an ODBC driver. The driver that you use must be on the same machine as the gateway. The non-Oracle … system platform availability, hardware resources and storage. Note: The ODBC driver may require non … ODBC driver