Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
917 views
in Technique[技术] by (71.8m points)

database - Getting an ORA - 00907 error on the following at ON UPDATE

When implementing my oracle database I receive an ORA-00907 error on line 8 at ON UPDATE. Its complaining about right parenthesis but I don't see this error anywhere. whats my issue?

CREATE TABLE Result (
Rid number,
Hid number,
Jid number,
Jweight number(5),
Place number(3),
CONSTRAINT Result_PK PRIMARY KEY(Rid, Hid, Jid),
CONSTRAINT ResultRACE_FK FOREIGN KEY(Rid) REFERENCES Race(Rid) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT ResultHORSE_FK FOREIGN KEY(Hid) REFERENCES Horse(Hid) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT ResultJOCKEY_FK FOREIGN KEY(Jid) REFERENCES Jockey(Jid) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT Jweight_Check CHECK(Jweight > 0 AND Jweight < 116))
See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

Oracle RDBMS does not support ON UPDATE CASCADE.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...