Hi All,

I have the following trigger:

create or replace trigger TRG_ACCOUNT before insert or
update on ACCOUNT for each row

BEGIN
IF INSERTING THEN
:new.CREATE_USER_ID := USER;
:new.UPDATE_USER_ID := USER;
:new.CREATE_DATE := SYSDATE;
:new.UPDATE_DATE := SYSDATE;
ELSE
:new.UPDATE_USER_ID := USER;
:new.CREATE_USER_ID := ld.create_user_id;
:new.create_date := ld.create_date;
:new.update_date := SYSDATE;
END IF;
END;

It works in Oracle 10g environment for about 8-10 hours, then it fails by throwing Ora-06502 error:

]ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "TCAMSYS.TRG_ACCOUNT".

Any help is greatly appreciated.

Nash