what's wrong with this trigger?

From: Troy Perchotte <max_at_headroom.com>
Date: Wed, 19 Aug 1998 16:38:24 -0700
Message-ID: <35DB61EF.44C28FC9@headroom.com>

I have a field that I would like to contain the upper case value of another field.

If a user changes the value of my 'customer_name field', I would like to have the new value, in upper case, written to the 'customer_name_idx' field. (This is done because I use the customer_name_idx field for doing faster searches)

A trigger something like the following (preferably one that actually works though):

...
begin

   if updating then

      update customers
      set customer_name_idx=upper(:new.customer_name);

   end if;
end;

Troy Perchotte Received on Wed Aug 19 1998 - 18:38:24 CDT