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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: INSERT ERROR

RE: INSERT ERROR

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Fri, 8 Apr 2005 16:57:59 -0400
Message-ID: <002901c53c7d$a549e870$2004a8c0@development.perceptron.com>


Or,
There is an "on insert" trigger which references another table, which doesn't exist.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Friday, April 08, 2005 3:54 PM
To: oracledbam_at_hotmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: INSERT ERROR

The name of the table is incorrect.

On Apr 8, 2005 9:21 PM, Seema Singh <oracledbam_at_hotmail.com> 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
Received on Fri Apr 08 2005 - 17:01:53 CDT

Original text of this message

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