Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 10G and Trigger Problem

Re: Oracle 10G and Trigger Problem

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 17 Feb 2006 20:41:58 +0100
Message-ID: <dt586r$l0k$1@news2.zwoll1.ov.home.nl>


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

>
> I told the whole story. On 9i no Problems with the mentionend Oracle
> release reproducable with XP and Linux
> Here are again the release copied from sqlplus
>

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



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
-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Fri Feb 17 2006 - 13:41:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US