Strange ora:00604 error in Forms

Hi,

[Quoted] I am building an application using Oracle Forms4.0. The form has several buttons and blocks which has some cursors in it. It runs fine at the beginning, while after I hit some buttons several times, I get a strange error-ORA 00604:

[Quoted] 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.

I have no idea why this happens. I've tried to write "commit" after each update statement. But it's helpless.

What is "recursive SQL statement"? In FORMS which tables are considered to be internal dictionary tables? In my application, I only have explicit SQL statements which access my own schema. The only possible access to "internal dictionary table" is:

        select SYSDATE from dual;

Anyone knows what has caused this to happen?

Thanks. Received on Tue Apr 14 1998 - 00:00:00 CEST