ERROR: Unknown column in WHERE clause
Here is the trigger for the Song_Entry table after insert:
UPDATE Contest
SET Songs_Entered =
(Songs_Entered + 1)
WHERE Contest.Contest_id =
Song_Entry.Contest_id;
I keep getting the above error message that says Song_Entry.Contest_id is unknown.
Subject
Views
Written By
Posted
ERROR: Unknown column in WHERE clause
881
January 04, 2022 11:23AM
329
January 04, 2022 01:50PM
738
January 04, 2022 03:21PM
310
January 04, 2022 04:16PM
320
January 04, 2022 05:17PM
330
January 04, 2022 09:44PM
504
January 04, 2022 11:09PM
275
January 05, 2022 12:00PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.