Problem using INTERVAL DAY TO SECOND

From: Ram <ramsnis_at_rediffmail.com>
Date: 15 Mar 2004 19:39:46 -0800
Message-ID: <3231117f.0403151939.f2bc5c0@posting.google.com>

Hello everyone,

   I am getting a "ORA-00907: missing right parenthesis" error when i am trying to create a table. The error lies in using the "INTERVAL DAY TO SECOND"
 in the create table statement. I am using Oracle 8i (windows 2000).

Here is the error:

SQL> CREATE TABLE project_consultant
  2 (p_id NUMBER(6),
  3 c_id NUMBER(6),
  4 roll_on_date DATE,
  5 roll_off_date DATE,
  6 elapsed_time INTERVAL DAY(6) TO SECOND,   7 CONSTRAINT project_consultant_pk PRIMARY KEY (p_id, c_id),   8 CONSTRAINT project_consultant_p_id_fk FOREIGN KEY (p_id) REFERENCES project(p_id),
  9 CONSTRAINT project_consultant_c_id_fk FOREIGN KEY (c_id) REFERENCES consultant(c_id));
elapsed_time INTERVAL DAY(6) TO SECOND,

                      *

ERROR at line 6:
ORA-00907: missing right parenthesis

Could anyone please help me.

Thanks,

Ram Received on Mon Mar 15 2004 - 21:39:46 CST