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

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 Received on Fri Mar 05 2004 - 15:50:13 CST