ORA-907 When Using INTN Data Type (Sybase) With SQL Developer 1.5 (Doc ID 988749.1)

Last updated on APRIL 20, 2010

Applies to:

Oracle SQL Developer - Version: 1.5.4 to 1.5.4.59.40
Information in this document applies to any platform.

Symptoms

Using Sybase, using INTN data type.

Create table statement from SQL Developer causes error -

create table t1 ( X intn(1,0));
create table t1 ( X intn(1,0))
*
ERROR at line 1:
ORA-00907: missing right parenthesis

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms