A remote server with server class ORAODBC is an Oracle Database version 8.0 or later.
Sybase certifies the use of the Oracle Database version 8.0.03 ODBC driver. Configure and test your ODBC configuration using the instructions for that product.
The following is an example of a CREATE EXISTING TABLE statement for an Oracle Database server named myora:
CREATE EXISTING TABLE employees AT 'myora.database.owner.employees';
When you execute a CREATE TABLE statement, SAP Sybase IQ automatically converts the data types to the corresponding Oracle Database data types using the following data type conversions.
| SAP Sybase IQ data type | Oracle Database data type |
|---|---|
| BIT | number(1,0) |
| VARBIT(n) | if (n <= 255) raw(n) else long raw |
| LONG VARBIT | long raw |
| TINYINT | number(3,0) |
| SMALLINT | number(5,0) |
| INTEGER | number(11,0) |
| BIGINT | number(20,0) |
| UNSIGNED TINYINT | number(3,0) |
| UNSIGNED SMALLINT | number(5,0) |
| UNSIGNED INTEGER | number(11,0) |
| UNSIGNED BIGINT | number(20,0) |
| CHAR(n) | if (n <= 255) char(n) else long |
| VARCHAR(n) | if (n <= 2000) varchar(n) else long |
| LONG VARCHAR | long |
| NCHAR(n) | if (n <= 255) nchar(n) else nclob |
| NVARCHAR(n) | if (n <= 2000) nvarchar(n) else nclob |
| LONG NVARCHAR | nclob |
| BINARY(n) | if (n > 255) long raw else raw(n) |
| VARBINARY(n) | if (n > 255) long raw else raw(n) |
| LONG BINARY | long raw |
| DECIMAL(precision, scale) | number(precision, scale) |
| NUMERIC(precision, scale) | number(precision, scale) |
| SMALLMONEY | numeric(13,4) |
| MONEY | number(19,4) |
| REAL | real |
| DOUBLE | float |
| FLOAT(n) | float |
| DATE | date |
| TIME | date |
| TIMESTAMP | date |
| TIMESTAMP WITH TIMEZONE | varchar(254) |
| XML | long raw |
| ST_GEOMETRY | long raw |
| UNIQUEIDENTIFIER | raw(16) |
Supply a connection string in the USING clause of the CREATE SERVER statement to connect to an Oracle database.
CREATE SERVER TestOracle CLASS 'ORAODBC' USING 'DRIVER=Oracle ODBC Driver;DBQ=mydatabase;UID=username;PWD=password'