Home -> Usenet -> comp.databases.oracle -> Re: Warning: Trigger created with compilation errors.

Re: Warning: Trigger created with compilation errors.

From: Stephen Bell <stephen.bell_at_cgi.ca>
Date: Wed, 02 May 2001 14:04:50 -0400
Message-ID: <3AF04C42.2F54021F_at_cgi.ca> 







Hi,


What does it tell you when you type 'show errors' after the warning message?



Unknown User wrote:



> 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 - 20:04:50 CEST












Original text of this message