Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

Here is a screenshot of table test4

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft SQL Server 2012 Unleashed

Authors: Ray Rankins, Paul Bertucci

1st Edition

0133408507, 9780133408508

More Books

Students also viewed these Databases questions

Question

3. What are potential solutions?

Answered: 1 week ago