What's wrong with this trigger

I'm trying to troubleshhot a problem created when I upgraded a third party application that logs data inot Oracle.

My present working theory is thta the app is pading it's text fields with spaces. In order to test this theory, I am trying to create a trigger that will strip of all trailing spcase. The text fileds that I am puting in should contain no spaces at all. So I have created the following trigger:

/*

        Create Triger For MWH_LOG */
create or replace trigger MWH_LOG_trig
before insert on MWH_LOG for each row
declare

   l_id char;
begin

   l_id := rtrim(:new.BRKR_ID,' ')
   :new.BRKR_ID := l_id;
end;
/

But, I cna't get Oracle (7.3.4) to accept it. The table MWH_LOG does conatin a column named BRKR_ID, so what stupid mistake am I making here? Received on Tue May 08 2001 - 13:47:10 CDT