Re: ORA-00905: missing keyword Need advice

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 17 Oct 2005 15:41:18 GMT
Message-ID: <1129563677.525811@proxy.dienste.wien.at>

FutureZone <bluestar77_at_walla-dot-com.no-spam.invalid> wrote:
> I've got this error when I create a table called "Offering" in
> SQL*Plus as follow:
>

[...]
> CONSTRAINT FKCourseNo FOREIGN KEY(CourseNo) REFERENCES
> Course ON DELETE NO ACTION

[...]
>
> But the error saying missing key... What's wrong with my code? Any
> guidance? Thnks :)

You do not specify which column in Course you reference. It should be something like
FOREIGN KEY (CourseNo) REFERENCES Course (No)

Yours,
Laurenz Albe Received on Mon Oct 17 2005 - 10:41:18 CDT