Question: Receiving the following error when attempting to create trigger in oracle. The goal is to: modify the EventLog trigger that it will store all changed
Receiving the following error when attempting to create trigger in oracle. The goal is to:
modify the EventLog trigger that it will store all changed (deleted or updated) values
from the Product table in the test4 table

Here is a screenshot of table test4

Worksheet Query Builder 1 E CREATE or replace TRIGGER eventLog 2 AFTER UPDATE OR DELETE ON PRODUCTTABLE 3 FOR EACH ROW 5E CASE 6 HEN UPDATING THEN 8 INSERT IHTO test4(PRODUCTID, PRODUCTNAME, LISTPRICE, CATEGORY) 10 VALUES (HEW. PRODUCTID, HEW. PRODUCTTAME, HEW. LISTPRICE, HEW. CATEGORY) 12 HEN DELETING THEN 13 14 INSERT INTO test4 (PRODUCTID , PRODUCTNAME , LISTPRCE, CATEGORY) 15 16 VALUES (OLD. PRODUCTID, OLD. PRODUCTTAME, OLD.LISTPRICE, OLD. CATEGORY) 17 18 END CASE 19 END 21 Compiler - Log x Project: sqldev, temp:/IdeConnections%23test.pr test Error(5,1): PL/SQL: SQL Statement ignored Error(7,60): PL/SQL: ORA-00984: column not allowed here Error (11,1): PL/SQL: SQL Statement ignored Error (13,60): PL/SQL: ORA-00984: column not allowed here electfrom test4 Query Result x SOL | All Rows Fetched : O in 0.089 seconds PRODUCTID PRODUCTNAMELISTPRICE CATEGORY
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
