RE: INSERT ERROR
- From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
- To: <kutrovsky.oracle@xxxxxxxxx>
- Date: Mon, 11 Apr 2005 12:40:52 -0400
Agree.
Igor Neyman, OCP DBA
ineyman@xxxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Christo Kutrovsky
Sent: Monday, April 11, 2005 11:37 AM
To: ineyman@xxxxxxxxxxxxxx
Cc: jkstill@xxxxxxxxx; oracledbam@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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 <ineyman@xxxxxxxxxxxxxx> wrote:
> 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
>
--
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
