update restrict question...

From: <AWI>
Date: 2000/09/20
Message-ID: <39c83a79@naylor.cs.rmit.edu.au>#1/1

I get the following error :

                ON UPDATE RESTRICT)


                *

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

                ON UPDATE RESTRICT)


                *

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

from the following,

DROP TABLE FULLTIMESTAFF;
DROP TABLE PARTTIMESTAFF;
DROP TABLE EMPLOYEE; CREATE TABLE EMPLOYEE (

        EMPLOYEEID VARCHAR2(10) NOT NULL,
        FIRSTNAME VARCHAR2(10) NOT NULL,
        LASTNAME VARCHAR2(10) NOT NULL,
        ADDRESS VARCHAR2(50),
        GENDER VARCHAR2(1),
        AGE NUMBER(3),
        CONTACTPERSON VARCHAR2(20),
        CONTACTPERSONADDRESS VARCHAR2(50),
        EMPLOYEETYPE VARCHAR2(20) NOT NULL
        CHECK (EMPLOYEETYPE IN ('FULLTIMESTAFF', 'PARTTIMESTAFF')),
        PRIMARY KEY (EMPLOYEEID));

CREATE TABLE FULLTIMESTAFF (
        EMPLOYEEID VARCHAR2(10) NOT NULL,
        ANNUALSALARY    NUMBER(7,2),
        ANNUALLEAVE INTEGER,
        PERKSALLOWED VARCHAR2(100),
        PRIMARY KEY(EMPLOYEEID),
        FOREIGN KEY(EMPLOYEEID) REFERENCES EMPLOYEE
                ON DELETE CASCADE
                ON UPDATE RESTRICT);

CREATE TABLE PARTTIMESTAFF (
        EMPLOYEEID VARCHAR2(10) NOT NULL,
        CASUALRATE NUMBER(3,2),
        HOURSWORKED NUMBER(3,2),
        EMPLOYEETYPE VARCHAR2(20)
        CHECK (EMPLOYEETYPE IN ('CONTRACTSTAFF')),
        PRIMARY KEY (EMPLOYEEID),
        FOREIGN KEY (EMPLOYEEID)  REFERENCES EMPLOYEE
                ON DELETE CASCADE
                ON UPDATE RESTRICT);

can anyone help?
thanks!! Received on Wed Sep 20 2000 - 00:00:00 CDT