SQL Keep getting error with ON UPDATE CASCADE

Hello everybody so i am working this "ON UPDATE CASCADE" feature and i still can't get it work.

my 1st table:

CREATE TABLE Stab
(
Stab_id int not null,
Sprache VARCHAR2(2000),
Vorname VARCHAR2(2000) not null,
Nachname VARCHAR2(2000) not null,
Geburtsatg date,
Nationalität VARCHAR2(2000),
Geschlecht VARCHAR2(2000) not null,
Kontakt VARCHAR2(2000) not null,
PRIMARY KEY (stab_id)
);

there is no problem with the 1st table

and i want my 2nd table with the first column "Stab_id" (like in the 1st table) is the foreign key of the 1st table. So when i change values in column "Stab_id" from 1st table, the "Stab_id" from 2nd table will change too.

CREATE TABLE Schauspieler
(
    Stab_id INT not null,
    Filmanzahl number(5,5),

    CONSTRAINT fk_Stabschau
    FOREIGN KEY (stab_id)
    REFERENCES stab (stab_id)
    ON DELETE CASCADE
    ON UPDATE CASCADE);

But i keep getting error under the line "ON UPDATE CASCADE"

Fehlerbericht - SQL-Fehler: ORA-00907: missing right parenthesis 00907. 00000 - "missing right parenthesis"

*Cause:
*Action:

can someone please help me. Thank you very much


Solution 1:

Oracle does not have "ON UPDATE CASCADE". You can manually emulate this behavior by using triggers