Oracle 10G and Trigger Problem

I have an Oracle 10G Enterprise Edition 10.2.0.1.0 with a standard installation on XP-Pro. Now I detected a strange behaviour. I made a reproducable example>

create table xx (feld varchar2(32));
alter table xx add primary key (FELD);

Until now everything works fine. Also my insert command

insert into xx (Feld) values (USER)

After then I created a Trigger like following

CREATE OR REPLACE TRIGGER TMS.XX$TGBI
before insert on XX for each row
BEGIN
:new.FELD:= upper(:new.FELD);
END ;
/

insert into xx (Feld) values (USER)

Now this command results into ORA 1400 Einfügen von Null in Feld nicht möglich
If I insert a constant value like 'XXX' it works as expected. Only if I use the function USER the error comes
Under 9i I do not get such an error.

Does someone give me a tip in metalink I did not find something helpful, but perhaps I used wrong key words

Regards
Nicolas Received on Thu Feb 16 2006 - 05:37:11 CST