begin insert into ec_subcategories_audit ( subcategory_id, category_id, subcategory_name, sort_key, last_modified, last_modifying_user, modified_ip_address ) values ( old.subcategory_id, old.category_id, old.subcategory_name, old.sort_key, old.last_modified, old.last_modifying_user, old.modified_ip_address ); return new; end;