Re: Oracle 10G and Trigger Problem

On Thu, 16 Feb 2006 12:37:11 +0100, "Nicolas Bronke" <Nicolas_Bronke_at_web.de> wrote:

>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.

--
Sybrand Bakker, Senior Oracle DBA