foreign key rule error

From: victorrhee <member_at_dbforums.com>
Date: Mon, 21 Oct 2002 14:48:12 +0000
Message-ID: <1953229.1035211692@dbforums.com>

Hi
Yep, I'm a newbie who needs some help. I really have tried and just haven't been able to sort it out.
I'm getting an error message
"Error at line 9
ORA-00907: missing right parenthesis".

I've checked and it definitely isn't really about a parenthesis that's not there. HEEEELP, I'm growing old and pulling my hair out (not a good look).

Here's my code, please enlighten me.

---

create table WORKLOAD
(

    ENO char(4) not null,
    PNO char(4) not null,
    LOAD number(2,1) not null,
    primary key (ENO, PNO),
    foreign key (ENO) references EMPLOYEE

            on delete cascade
            on update cascade,
    foreign key (PNO) references PROJECTS
            on delete cascade
            on update cascade

);

---

Thanks in advance
Vic

--
Posted via http://dbforums.com

Received on Mon Oct 21 2002 - 09:48:12 CDT