ORA-00904: "ACTION": invalid identifier

[viny2cool]

Hey guys I am trying to create an trigger, but getting this error. My code is as follows

CREATE OR REPLACE TRIGGER vendorpricingTR
BEFORE UPDATE OF pricing ON vendors
FOR EACH ROW
DECLARE 
ActionVar char(6);
BEGIN

IF UPDATING THEN
ActionVar :=’UPDATE’;
END IF;
INSERT into VENDORS
(vendorsname,addr,pricing,ratings, Action)
VALUES (:old.vendorsname, :old.addr, :new.pricing,  :old.ratings, Actionvar);

END;

error is

LINE/COL ERROR
-------- -----------------------------------------------------------------
8/1 PL/SQL: SQL Statement ignored
9/36 PL/SQL: ORA-00904: "ACTION": invalid identifier

[debasisdas]

Is action a field in your table ?

[viny2cool]

Action is a new column I want to insert in the table.......... .....

[amitpatel66]

Can you please post the output of the below command here for reference:

[code=oracle]

SQL> desc VENDORS

[/code]

[debasisdas]

the column must exist in the table to insert the value into it.

[Saii]

Re-check your trigger code for following
1. There are no :old values when inserting to a table.
2. This is row level trigger, you need to store the values of the row to use it later.

[dbcodeerror]

Hi,

This oracle error Action is : Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word.

Source : http://www.dbcodeerror.com/oracle-da...id-identifier/