Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 10G and Trigger Problem
Nicolas Bronke 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> >>> >> You are not telling the whole story...
No - or you would have had the PK violation.
> Verbunden mit:
> Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
> With the Partitioning, OLAP and Data Mining options
>
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
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Fri Feb 17 2006 - 13:41:58 CST
![]() |
![]() |