Server Class oraodbc

A server with server class oraodbc is Oracle version 8.0 or later.

Notes:

SAP Sybase certifies the use of the Oracle 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 server named myora:
```
CREATE EXISTING TABLE employees
AT 'myora.database.owner.employees';
```
As a result of Oracle ODBC driver restrictions, you cannot issue a CREATE EXISTING TABLE statement for system tables. A message returns stating that the table or columns cannot be found.

Data Type Conversions: Oracle

When you issue a CREATE TABLE statement, the database server automatically converts the data types to the corresponding Oracle data types using the following data type conversions.

SAP Sybase IQ Data Type	Oracle Data Type
BIT	number(1,0)
TINYINT	number(3,0)
SMALLINT	number(5,0)
INT	number(11,0)
BIGINT	number(20,0)
DECIMAL(prec, scale)	number(prec, scale)
NUMERIC(prec, scale)	number(prec, scale)
FLOAT	float
REAL	real
SMALLMONEY	numeric(13,4)
MONEY	number(19,4)
DATE	date
TIME	date
TIMESTAMP	date
SMALLDATETIME	date
DATETIME	date
CHAR(n)	if (n > 255) long else varchar(n)
VARCHAR(n)	if (n > 2000) long else varchar(n)
LONG VARCHAR	long or clob
BINARY(n)	if (n > 255) long raw else raw(n)
VARBINARY(n)	if (n > 255) long raw else raw(n)
LONG BINARY	long raw