CODEWITHSUNDEEP
sqloracle-databaseplsql
Boudewijn Visser
Boudewijn Visser

Reputation: 3

ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword

I am writing some PL/SQL code for a apex database application. With the code a want to realise that when I make a purchase order, a purchase orderline is automatically generated based on the purchase order_id. However, I'm getting a ORA-04071 error running the code below:

create or replace trigger "INKOOPORDER_T1"/
AFTER insert or update or delete on INKOOPORDER
for each row begin

INSERT INTO INKOOPORDERREGEL
    (I_nummer)
SELECT
    I_nummer
    FROM inkooporderregel
go
end/

Can somebody help me please?

Upvotes: 0

Views: 2596

Answers (1)

Sachu
Sachu

Reputation: 7766

ur query has some syntax errors

try below code

I removed / from first line and after End, put ; at the end of insert statement and deleted go.Also after end a ;

create or replace trigger "INKOOPORDER_T1"
AFTER insert or update or delete on INKOOPORDER
for each row 
begin

INSERT INTO INKOOPORDERREGEL
    (I_nummer)
SELECT
    I_nummer
    FROM inkooporderregel;

end;

Upvotes: 1

Related Questions