From oracle-l-bounce@freelists.org Mon Apr 11 12:45:36 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3BHja9Q004739 for ; Mon, 11 Apr 2005 12:45:36 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j3BHjZem004735 for ; Mon, 11 Apr 2005 12:45:35 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C124E93C70; Mon, 11 Apr 2005 11:43:26 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30976-04; Mon, 11 Apr 2005 11:43:26 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4605C93926; Mon, 11 Apr 2005 11:43:26 -0500 (EST) From: "Igor Neyman" To: Cc: , , Subject: RE: INSERT ERROR Date: Mon, 11 Apr 2005 12:40:52 -0400 Message-ID: <000701c53eb5$39e663d0$2004a8c0@development.perceptron.com> MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 In-Reply-To: <52a152eb0504110936218561b4@mail.gmail.com> X-archive-position: 18308 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ineyman@perceptron.com Precedence: normal Reply-To: ineyman@perceptron.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.4 required=5.0 tests=AWL,SUBJ_ALL_CAPS autolearn=no version=2.60 X-Spam-Level: Agree. Igor Neyman, OCP DBA ineyman@perceptron.com -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Christo Kutrovsky Sent: Monday, April 11, 2005 11:37 AM To: ineyman@perceptron.com Cc: jkstill@gmail.com; oracledbam@hotmail.com; oracle-l@freelists.org Subject: Re: INSERT ERROR Dont forget that the trigger must refering (or doing) this insert dynamically. Otherwise it would be invalid. On Apr 8, 2005 4:57 PM, Igor Neyman wrote: > Or, > There is an "on insert" trigger which references another table, which > doesn't exist. > > Igor Neyman, OCP DBA > ineyman@perceptron.com > > > -----Original Message----- > From: oracle-l-bounce@freelists.org > [mailto:oracle-l-bounce@freelists.org] On Behalf Of Jared Still > Sent: Friday, April 08, 2005 3:54 PM > To: oracledbam@hotmail.com > Cc: oracle-l@freelists.org > Subject: Re: INSERT ERROR > > The name of the table is incorrect. > > On Apr 8, 2005 9:21 PM, Seema Singh wrote: > > Hi, > > I'm getting following errors when inserting datat into 1 table. > > * > > ERROR at line 1: > > ORA-00604: error occurred at recursive SQL level 1 > > ORA-00942: table or view does not exist > > > > Any thoughts? > > thanks > > > > -- > > http://www.freelists.org/webpage/oracle-l > > > > -- > Jared Still > Certifiable Oracle DBA and Part Time Perl Evangelist > -- > http://www.freelists.org/webpage/oracle-l > > -- > http://www.freelists.org/webpage/oracle-l > -- Christo Kutrovsky Database/System Administrator The Pythian Group -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l