Re: Forms 4.0.13 Cannot Commit

In article <kenho.145.2ED3229A_at_hk.super.net>, kenho_at_hk.super.net (Kenneth Ho) writes:

> Hi, Oracle gurus
>
> I am using Forms 4.0.13 on MS Windows.
>
> I have developed a form, which contains a lot of base table blocks and
> there is a block having a lot of base table fields (More that 70!).
>
> After I enter all the data in the form and I try to commit, I get the
> following Oracle Error:
>
> ORA-00604: Error occurred at recursive SQL Level 1
> ORA-01000: Maximum open cursors exceeded.
>
> What does it mean??
>
> How can I fix this??
>
> Any pointer will be greatly appreciated.
>
> Ken
>
>

Hi,

Increase the value of open_cursors= in the init.ora also increase the value of log_buffer=. My init.ora is set to: open_cursors=100 and log_buffer=32768, this is for a small database, look it up in the administrator's guide. Hope this helps.

Jean-Claude                        Ottawa, Ontario CANADA
jcl_at_sparky.crad.dnd.ca             Desk: (613) 992-0212
                                   Fax : (613) 996-5177
_________________________________________________________