Re: INSERT ERROR
- From: Christo Kutrovsky <kutrovsky.oracle@xxxxxxxxx>
- To: ineyman@xxxxxxxxxxxxxx
- Date: Mon, 11 Apr 2005 12:36:47 -0400
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
Other related posts:
