Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Norway
    Posts
    4

    Unanswered: Simple query problem..

    Trying to get an UPDATE CASCADE to work, but keep getting problems..

    create table Thread(
    ThreadID number (3) NOT NULL PRIMARY KEY,
    Emne varchar(100),
    ForumID number(3),
    FOREIGN KEY (ForumID) REFERENCES Forum(ForumID)
    UPDATE CASCADE
    );
    ORA-00907: missing right parenthesis

    create table Thread(
    ThreadID number (3) NOT NULL PRIMARY KEY,
    Emne varchar(100),
    ForumID number(3),
    FOREIGN KEY (ForumID) REFERENCES Forum(ForumID)
    ON UPDATE CASCADE
    );
    ORA-00905: missing keyword

    Anybody got an idea how this works?

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Simple query problem..

    It doesn't UPDATE CASCADE is not an option supported by Oracle.

  3. #3
    Join Date
    Feb 2004
    Location
    Norway
    Posts
    4

    Re: Simple query problem..

    Oh, sorry...thanx!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •