Oracle deleting rows from multiple tables

Question

i'm trying to delete rows from multiple tables but i'm getting a syntax error at medewerkers m,

Can anyone tell me what i'm doing wrong here? :

declare
v_mnr medewerkers.mnr%type;
procedure ontsla_med(p_mnr in medewerkers.mnr%type)
IS
BEGIN
    DELETE FROM medewerkers m, INSCHRIJVINGEN i , UITVOERINGEN u WHERE m.MNR = p_mnr and i.cursus = p_mnr and u.docent = p_mnr;
END ontsla_med;
BEGIN
    ontsla_med(7000);
END;

Seems like the delete statement is wrong?

Alternatively, you might be trying to delete data from parent and child tables, in which case you might want to create foreign key constraints with the ON DELETE CASCADE option. — kfinity
– kfinity, Commented Sep 26, 2018 at 20:35

Error_2646 · Accepted Answer · 2018-09-26 20:27:56Z

6

Can't do it. It has to be three separate deletes.

DELETE 
  FROM medewerkers
 WHERE mnr = p_mnr;

DELETE 
  FROM UITVOERINGEN 
 WHERE cursus = p_mnr;

DELETE 
  FROM UITVOERINGEN 
 WHERE docent = p_mnr;

answered Sep 26, 2018 at 20:27

Error_2646

3,8991 gold badge17 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

J. Adam Over a year ago

Thanks, thought it was possible to add multiple tables at once

Collectives™ on Stack Overflow

Oracle deleting rows from multiple tables

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related