Re: ORA-00604 error at recursive SQL level 1
Date: 1995/06/20
Message-ID: <3s6cpo$kuj_at_imp.demon.co.uk>#1/1
Sue
OK, this is a common problem, not restricted to ORACLE7.
Firstly, I can probably guess your problem, but an explanation will probably help. The 604 is the last error on the stack. The real error can only be gotten to if you read through the error stack, and I have not encountered a method of doing this through FORMS as yet, however there is a method involving editting your init.ora file.
Within INIT.ORA you can add a line to force a stack trace to occur into a trace file. The line reads something like
event = "604 trace name errorstack"
Shutdown, Startup, re-run the form, get the error and a file will be written into your trace directory (usually $ORACLE_HOME/rdbms/log"). Your real error will appear somewhere in here.
As I said, my guess would be that you have either
you have run out of cursors, SGA space etc.
or
a table is attempting to dynamically extend and cannot
If you e-mail me your fax number I can send you the ORACLE technical document which describes the above in more detail (ant probably a damn site clearer too!)
Hope this helps
John Peat Received on Tue Jun 20 1995 - 00:00:00 CEST