Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 10G and Trigger Problem
> Confirmed:
>
> Trigger created.
>
> SQL> insert into blah values(user);
> insert into blah values(user)
> *
> ERROR at line 1:
> ORA-01400: cannot insert NULL into ("SCOTT"."BLAH"."COL1")
> SQL> select * from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
> PL/SQL Release 10.2.0.1.0 - Production
> CORE 10.2.0.1.0 Production
> TNS for Linux: Version 10.2.0.1.0 - Production
> NLSRTL Version 10.2.0.1.0 - Production
So I see you have the same probem with 10.2.0.1.0
Regards Nicolas Received on Fri Feb 17 2006 - 14:34:52 CST