Warning: Trigger created with compilation errors.
From: Unknown User <unknown_at_unknown.com>
Date: Tue, 01 May 2001 23:28:55 -0700
Message-ID: <a6avetsndhtccmbepgu2f64vbkgv31q67t_at_4ax.com>
Date: Tue, 01 May 2001 23:28:55 -0700
Message-ID: <a6avetsndhtccmbepgu2f64vbkgv31q67t_at_4ax.com>
Hello,
I am new to SQL/Oracle and need your help. I am using Oracle8i 8.1.7 on Windows 2000 SP1. Any ideas on what is causing the error?
SQL> create trigger pay_table_trigger
2 after update on pay_table
3 for each row
4 begin
5 insert into trans_table values
6 ('PAY CHANGE', :new.name, :old.pay_rate, :new.pay_rate, :new.eff_date);
7 end;
8 /
Warning: Trigger created with compilation errors. Received on Wed May 02 2001 - 08:28:55 CEST