Re: Problem using INTERVAL DAY TO SECOND

"Ram" <ramsnis_at_rediffmail.com> wrote in message news:3231117f.0403151939.f2bc5c0_at_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

i believe you're trying to use a 9i datatype in 8i

;-{ mcs Received on Tue Mar 16 2004 - 20:23:12 CST