Re: ORA-00604: error occurred at recursive SQL level 1

paddy_nyr wrote:
>
> "Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message
> news:4048F615.9840B35E_at_remove_spam.peasland.com...
> > paddy_nyr wrote:
> > >
> > > I get the above message plus ORA-00942: table or view does not exist
> when I
> > > try an update a row on a table in my database.
> > >
> > > The table exists and I'm not sure why this is happening.
> > >
> > > I'm running on a Sun Solaris 8 using Oracle 8.1.7.4
> > >
> > > Thanks
> >
> > Is there a trigger on the table you are updating? If so, it could be
> > trying to access a non-existent table.
> >
> > Also check to see if what you are accessing is a synonym and not a
> > table.
> >
> > Thanks,
> > Brian
> >
> I do a select * from table_a where col_a = 'A' and col_b = 'B' and it
> returns a number of rows
> Then when I try
>
> update table_a
> set col_c = 'C'
> where col_a = 'A' and col_b = 'B'
>
> Is when I get this message and it's happening to alot of my tables.
>
> I should point out that this is a new db and I imported a schema into the
> new db.

Did you verify, as I earlier suggested, that there is no UPDATE trigger on this table?

Cheers,
Brian Received on Sat Mar 06 2004 - 10:57:01 CST