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

"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. Received on Fri Mar 05 2004 - 22:58:41 CST