Re: ORA-00604 error at recursive SQL level 1

In article <3s687a$btg_at_gabriel.keele.ac.uk> sue_at_cs.keele.ac.uk (Sue Harding) writes:

>Can anyone help please? I've created a form using SQL*Forms 3 with Oracle 7,
>and I keep getting the error
 

> ORA-00604: error occurred at recursive SQL level 1
 

>after I've used it for a while to insert records. The error doesn't always
>appear at the same point in the form, but it seems to occur when inserting
>a record after quite a lot of records have already been inserted by a trigger.
>If I exit from the form, start it up again and repeat the operation that
>failed, it will then succeed.
 

>The form has lots of complicated triggers and procedures, and includes SQL
>INSERT statements in procedures called from KEY-COMMIT triggers which I
>suspect are the cause of the problem.
 

>Am I not allowed to use such statements under these circumstances, or is it
>the way I am using them? If I can't use them, how can I get the form to
>create a set of records based on information entered into the form together
>with information stored in another table?
 

>Any comments about the cause of the error or possible solutions will be
>gratefully received!

>Sue Harding
>sue_at_cs.keele.ac.uk

Try increasing the OPEN_CURSORS parameter in your init.ora and/or the MAXOPENCURSORS option in the form itself. This may help the situation - no promises thought ! :-)

Robin. Received on Tue Jun 20 1995 - 00:00:00 CEST