Re: Oracle ERROR 00604, 00000, "error occurred at recursive SQL level %s"

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/02
Message-ID: <957304034.26297.0.pluto.d4ee154e@news.demon.nl>#1/1

wls <cuba_at_ms.chttl.com.tw> schreef in berichtnieuws 957256705.172261_at_news.chttl.com.tw...
> Is there anyone know that what casued the following error ...
> 00604, 00000, "error occurred at recursive SQL level %s"
>
> How do I resolve the problem ... ?
>
>

Usually this message is followed by a second message with the exact error for the recursive sql. Without this message we can't resolve your problem. You could consider tracing the session and try to reproduce the problem, the recursive statement in error and the error number will be captured in the trace file.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue May 02 2000 - 00:00:00 CDT