Server class ORAODBC

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, SQL Anywhere automatically converts the data types to the corresponding Oracle Database data types using the following data type conversions.

SQL Anywhere 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'

Server class ORAODBC

Notes

Data type conversions: Oracle Database

Example