Re: ORA-00604 error at recursive SQL level 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