RE: INSERT ERROR

  • From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
  • To: <jkstill@xxxxxxxxx>, <oracledbam@xxxxxxxxxxx>
  • Date: Fri, 8 Apr 2005 16:57:59 -0400

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

Igor Neyman, OCP DBA
ineyman@xxxxxxxxxxxxxx



-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Friday, April 08, 2005 3:54 PM
To: oracledbam@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: INSERT ERROR

The name of the table is incorrect.

On Apr 8, 2005 9:21 PM, Seema Singh <oracledbam@xxxxxxxxxxx> 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
> 
> --
> //www.freelists.org/webpage/oracle-l
> 


-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l

Other related posts: