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@(protected)> wrote: > Or, > There is an "on insert" trigger which references another table, which > doesn't exist. > > Igor Neyman, OCP DBA > ineyman@(protected) > > > -- --Original Message-- -- > From: oracle-l-bounce@(protected) > [mailto:oracle-l-bounce@(protected)] On Behalf Of Jared Still > Sent: Friday, April 08, 2005 3:54 PM > To: oracledbam@(protected) > Cc: oracle-l@(protected) > Subject: Re: INSERT ERROR > > The name of the table is incorrect. > > On Apr 8, 2005 9:21 PM, Seema Singh <oracledbam@(protected)> wrote: > > Hi, > > I'm getting following errors when inserting datat into 1 table. > > * > > ERROR at line 1: > > ORA-00604 (See ORA-00604.ora-code.com): error occurred at recursive SQL level 1 > > ORA-00942 (See ORA-00942.ora-code.com): 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
