Compilation error on an Oracle Database Trigger

Question

I have been trying to compile this trigger for my table and I keep on getting this error:

Error message :

 Compilation failed, line 4 (19:39:58) The line numbers associated with
 compilation errors are relative to the first BEGIN statement. This
 only affects the compilation of database triggers. PL/SQL: ORA-00923:
 FROM keyword not found where expected

 Compilation failed, line 4
 (19:39:58) The line numbers associated with compilation errors are
 relative to the first BEGIN statement. This only affects the
 compilation of database triggers. PL/SQL: SQL Statement ignored

This is my Trigger :

Create or Replace Trigger NEWSALARY 
  before insert or update on CREW
  for each row
Declare 
  v_emphours AIRPLANE. EMPWORKINGHOURS%TYPE;
Begin
  select EMPWORKINGHOURS into v_ emphours 
    from "AIRPLANE" 
   where  AIRPLANEID =:NEW."AirPlaneID";
  if v_emphours > 8 then 
   :NEW."Salary":= :NEW."Salary"* 50;
  end if;
End;

Barbaros Özhan · Accepted Answer · 2017-12-11 19:07:22Z

2

there's a space in declaration part(grey one character-length area below)

v_emphours AIRPLANE.EMPWORKINGHOURS%TYPE;

and here

v_emphours

get rid of those spaces and removing useless quotations, you may run this statement without error :

create or replace TRIGGER  NEWSALARY 
before insert or update on CREW
for each row
Declare 
v_emphours AIRPLANE.EMPWORKINGHOURS%TYPE;
BEGIN
select EMPWORKINGHOURS into v_emphours from AIRPLANE Where  AIRPLANEID =:NEW.AirPlaneID;
if 
v_emphours > 8
then 
:NEW.Salary:= :NEW.Salary* 50;
END IF;
End;

edited Dec 11, 2017 at 19:07

answered Dec 11, 2017 at 18:49

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Compilation error on an Oracle Database Trigger

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related