Re: SQL Help..

Srinivas Rao Nallapati (srn1_at_Ra.MsState.Edu) wrote:
: Hai,
: I am frequently getting this SQL error when i am using both
: Forms4.0 and Proc.
: It says,
: ORA-0604 :error occured at recursive SQL level 1

Normally, you get a second error after a recursive SQL error. This second error indicates the real problem. Very often it is something like 'max. numbers of open cursors exceeded'. If that is the case, check the value of your open_cursors parameters in init.ora. Default this is set to 50 (i think). This might be too low for Forms 4.0

Olaf  

--
Olaf vd Geest                              Oracle Corporation
ogeest_at_nl.oracle.com                       Rijnzathe 6
                                           De Meern
----------------------------------------------------------------
*****        This is not official Oracle Support           *****
***** These opions are mine and not those of my employer   *****
----------------------------------------------------------------