Received: (qmail 21242 invoked from network); 2 Feb 2010 10:14:30 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 2 Feb 2010 10:14:20 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 75C65CCE970; Tue, 2 Feb 2010 11:14:18 -0500 (EST) X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id tyLYGrDz5fUA; Tue, 2 Feb 2010 11:14:18 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A1237CCE958; Tue, 2 Feb 2010 11:13:36 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 02 Feb 2010 11:12:55 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4E8B0CCE913 for ; Tue, 2 Feb 2010 11:12:55 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Qb7O7PSiT8KC for ; Tue, 2 Feb 2010 11:12:55 -0500 (EST) Received: from mail-vw0-f51.google.com (mail-vw0-f51.google.com [209.85.212.51]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 110B2CCE8D3 for ; Tue, 2 Feb 2010 11:12:54 -0500 (EST) Received: by vws17 with SMTP id 17so62259vws.10 for ; Tue, 02 Feb 2010 08:12:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :from:date:message-id:subject:to:cc:content-type; bh=RHQHA18KQVyXZUuriA80BnlxVvUo+401gbkLQKRpjk4=; b=BrEsiIiL2Hb6/l9/T5ku7EnQ12bSPAFvyBO6igz0nd0TBtdzBGT7Bz6kiQfRpao6LI rk8+/6KTePh3OmBXkvMsCo9zS6LSi8t4vVIQopR0bcP49pkX/p57FuKzdID8k5tpDSJu YiJ74fnWkKbGJ5gioErtvZRU3OFRYFx1VMXFk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; b=ExKLLppra+/0lTYKATZUtuZuHOqqLXAMi1MqUOxeaUucksJqelA+MGRTGjUqEU8Qj4 vvYR0CayTGTpl6ggYLpcLSNfUrMV3KVXwXsIX48zUcBGOViSjdfFW8zIWxL9xS1z7Dn5 gGyo3cFWewuEEtBd/nzRfCh939TCqg9T5Wpd4= MIME-Version: 1.0 Received: by 10.142.120.10 with SMTP id s10mr4171094wfc.103.1265127171631; Tue, 02 Feb 2010 08:12:51 -0800 (PST) In-Reply-To: <1D9C684CBA554E40B386D30AFF511BF3@as> References: <1D9C684CBA554E40B386D30AFF511BF3@as> From: Jared Still Date: Tue, 2 Feb 2010 08:12:30 -0800 Message-ID: Subject: Re: Constraint violation in spite of trigger with sequence To: stiebing@softcontract.de Cc: Oracle-L Freelists Content-Type: multipart/alternative; boundary=001636e0a71da92afa047ea05f3d X-archive-position: 25225 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-to: jkstill@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --001636e0a71da92afa047ea05f3d Content-Type: text/plain; charset=ISO-8859-1 On Tue, Feb 2, 2010 at 2:09 AM, A. Stiebing wrote: > > > In spite of we got an trigger with a sequence to update an unique id key on > insert, we get constraint violations from time to time. > Where could the cause be for that? > > 1) By what methods does data get into the table? Custom app? SQL Loader? Custom Utilities? Import? 2) Please post entire code for the trigger. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com --001636e0a71da92afa047ea05f3d Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
On Tue, Feb 2, 2010 at 2:09 AM, A. Stiebing <stiebing@soft= contract.de> wrote:


In spite of we got an trigger with a sequence to update an unique id key on=
insert, we get constraint violations from time to time.
Where could the cause be for that?


1) By what methods does data get into the table?=
=A0=A0=A0 Custom app?=A0 SQL Loader?=A0 Custom Utilities?=A0 Import?
2) Please post entire code for the trigger.


J= ared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home P= age: http://jaredstill.com

--001636e0a71da92afa047ea05f3d-- -- http://www.freelists.org/webpage/oracle-l