Re: Oracle 10G and Trigger Problem

>>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
>
> You were connected as SYS wheren't you? Various functions don't return
> a result when you are connected as SYSDBA.

No. I use sys only if really neccessary.

I tried with a special user, later also with scott and system and meanwhile also on a Linux database (same release) with the same results.

Regards Nicolas Received on Thu Feb 16 2006 - 12:44:26 CST