Missing right parenthesis

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • karlectomy
    New Member
    • Sep 2007
    • 64

    #1

    Missing right parenthesis

    Hi all,

    I'm trying to run this table creation script but I run into the ORA-00907 error: missing right parenthesis. Perhaps someone might know where I am going wrong?

    [CODE="sql"]
    CREATE TABLE RADLEX.radlinks (
    PID varchar(30) NOT NULL,
    CID varchar(30) NOT NULL,
    relation_type varchar(25) NOT NULL,
    preferred tinyint(1),
    PRIMARY KEY (PID,CID,relati on_type)
    )DEFAULT CHARSET=latin1 COLLATE=latin1_ general_ci;
    [/code]

    Best Wishes,

    karl
    Last edited by karlectomy; Dec 18 '07, 08:10 PM. Reason: Because I felt like it
  • amitpatel66
    Recognized Expert Top Contributor
    • Mar 2007
    • 2358

    #2
    Originally posted by karlectomy
    Hi all,

    I'm trying to run this table creation script but I run into the ORA-00907 error: missing right parenthesis. Perhaps someone might know where I am going wrong?

    [CODE="sql"]
    CREATE TABLE RADLEX.radlinks (
    PID varchar(30) NOT NULL,
    CID varchar(30) NOT NULL,
    relation_type varchar(25) NOT NULL,
    preferred tinyint(1),
    PRIMARY KEY (PID,CID,relati on_type)
    )DEFAULT CHARSET=latin1 COLLATE=latin1_ general_ci;
    [/code]

    Best Wishes,

    karl
    Try this:

    [code=oracle]
    SQL> ed
    Wrote file afiedt.buf

    1 CREATE TABLE APPS.radlinks (
    2 PID varchar(30) NOT NULL,
    3 CID varchar(30) NOT NULL,
    4 relation_type varchar(25) NOT NULL,
    5 preferred int,
    6 PRIMARY KEY (PID,CID,relati on_type)
    7* )
    SQL> /

    Table created.

    [/code]

    I have changed tinyint to int and removed DEFAULT CHARSET and COLLATE options

    Comment

    Working...