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