Re: Oracle 10G and Trigger Problem

Nicolas Bronke <Nicolas_Bronke_at_web.de> wrote:
> 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.

This is probably no big help, but I could reproduce the problem with the same Oracle version on Linux x86.

Yours,
Laurenz Albe Received on Fri Feb 17 2006 - 08:49:36 CST