3 Replies Latest reply: Jan 31, 2013 11:01 AM by 987899 RSS

    missing right parenthesis

    987899
      hello,
      i go this error :
      ERROR at line 10:
      ORA-00907: missing right parenthesis
      this is the code
       
      create table LIGNE_COMMANDE
      (NumProd  number(10), 
      Prix  number(11,2),
      Qtecom  number(9),
      NumCom  number(7),
      constraint pk_LICOM primary key(NumProd, NumCom),
      constraint ref_CLI 
           foreign key(NumCli) references CLIENT(NumCli),
      constraint ref_PROD 
           foreing key(NumProd) references PRODUIT(NumProd) 
      );
      there is no parenthesis missing.

      thank's
        • 1. Re: missing right parenthesis
          Frank Kulash
          984896 wrote:
          hello,
          i go this error :
          ERROR at line 10:
          ORA-00907: missing right parenthesis
          this is the code
           
          create table LIGNE_COMMANDE
          (NumProd  number(10), 
          Prix  number(11,2),
          Qtecom  number(9),
          NumCom  number(7),
          constraint pk_LICOM primary key(NumProd, NumCom),
          constraint ref_CLI 
               foreign key(NumCli) references CLIENT(NumCli),
          constraint ref_PROD 
               foreing key(NumProd) references PRODUIT(NumProd) 
          );
          The next-to-last line above has "foreign" mis-spelled. Change it to
          foreign key(NumProd) references PRODUIT(NumProd) 
          Also, you have a constraint for the column called NumCli, but no such column.
          there is no parenthesis missing.
          No, that error message occurs for all kinds of syntax errors, including mis-spelled key words. It would be more correct if the message read "Syntax error, such as missing right parenthesis". Missing right parenthesis might be the single most common cause of the error message, but it doesn't account for 50% of the occurrences, or anywhere near 50%.
          • 2. Re: missing right parenthesis
            987899
            i clicked by mistake, sorry
            • 3. Re: missing right parenthesis
              987899
              oh thank you, i'm new in sql