Re: Strange ora:00604 error in Forms

Hi.

ISTR a recursive SQL statement is one issued by the RDBMS to retrieve data dictionary stuff not currently held in cache anywhere. If this is having problems, it would suggest that either there's not enough memory - although I would have expected a more appropriate error message - or possibly some problem with the dictionaries. I *hope* I'm wrong about his, though. What did Oracle support say?

Jamie Keir

Wei Tang wrote:
>
> 00604, 00000, "error occurred at recursive SQL level %s"
> // *Cause: An error occurred while processing a recursive SQL statement
> // (a statement applying to internal dictionary tables).
> // *Action: If the situation described in the next error on the stack
> // can be corrected, do so; otherwise contact Oracle Support.
>

--
  _______________________________________________________________
 /###############################################################\
+--------------------+---------------+----------------------------+
| Oracle 7     DBA   | Digital Unix  | Jamie Keir                 |
| Developer*2000     | Windows NT 4  | jkerr_at_jameswatt.ac.uk      |
| PL*SQL             | AmigaOS 3     |                            |
| Unix Admin         | Linux         |                            |
| Network Support    | ADA           | ...now if I could just get |
|                    | C / C++       | them to *pay* me for it... |
| Alpha AXP          | M68040 Asm    |                            |
+--------------------+---------------+----------------------------+