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

Receiving the following error when attempting to create trigger in oracle. The

Here is a screenshot of table test4

goal is to: modify the EventLog trigger that it will store all

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

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!