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_at_perceptron.com> wrote:
> 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
>

-- 
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
http://www.freelists.org/webpage/oracle-l