Question: i want to mele a trigger function i have table named repairjob and a column customer_cpr , please help me find where is my mistake

i want to mele a trigger function i have table named repairjob and a column customer_cpr , please help me find where is my mistake
i want to mele a trigger function i have table named repairjob
and a column customer_cpr , please help me find where is my

1. CREATE OR REPLACE TRIGGER trg_prevent_multiple_repair_jobs 2 BEFORE INSERT OR UPDATE ON REPAIRJOB 3 FOR EACH ROW 4 BEGIN IF (SELECT COUNTT ) FROM REPAIRJOB WHERE CUSTOMER_CPR = :new.CUSTOMER_CPR) >3 THEN RAISE_APPLICATION_ERROR(-20001, 'Customer cannot have more than 3 repair jobs' ); END IF; 8 END; - ( * 8.8+;1 at for mod remainder rem can exponent (**)> and or group having intersect minus order start union where connect || indicator multiset Error at line 2: PLS-BB103: jeji 4?1 g pa "SELECT" qutiti Eig tis: ( - + case inod new not null can identifiers sa double-quoted delinited-identifiers

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!