Re: Warning: Trigger created with compilation errors. <-- RESOLVED

Thanks Stephen,

I typed 'show errors' and Oracle said I didn't have the table trans_table. My mistake and the problem is now resolved. Thanks for your help.

On Wed, 02 May 2001 14:04:50 -0400, Stephen Bell <stephen.bell_at_cgi.ca> wrote:

>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 - 21:36:20 CEST