Hello Naresh,
Friday, August 24, 2001, 8:39:00 AM, you wrote:
NC> Close all the connections in ur program
NC> You can also increase the max number of connections
NC> in DB Server.
>> -----Original Message-----
>> From: Geeta Ramani [SMTP:[EMAIL PROTECTED]]
>> Sent: Thursday, August 23, 2001 10:03 PM
>> To: [EMAIL PROTECTED]
>> Subject: Re: EXCEPTION
>>
>> Hi Julian:
>>
>> Make sure you close every statement you create (and every connection you
>> make
>> to your database). That may do the trick.
>>
>> Geeta
>>
>> Julian Eduardo de Anquin wrote:
>>
>> > I'am getting this excpection when executing some query and inserts into
>> > Oracle, ORA-01000: maximum open cursors exceeded ORA-06512: at
>> > "SA2.tr_CELDAS", line 2 ORA-04088: error during execution of trigger
>> > 'SA2.tr_CELDAS'
>> > any clue?
>> > Julian
>> >
>> >
>> __________________________________________________________________________
>> _
>> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
>> body
>> > of the message "signoff SERVLET-INTEREST".
>> >
>> > Archives: http://archives.java.sun.com/archives/servlet-interest.html
>> > Resources: http://java.sun.com/products/servlet/external-resources.html
>> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>>
>> __________________________________________________________________________
>> _
>> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
>> body
>> of the message "signoff SERVLET-INTEREST".
>>
>> Archives: http://archives.java.sun.com/archives/servlet-interest.html
>> Resources: http://java.sun.com/products/servlet/external-resources.html
>> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
U can increse parameter for open_cursors your init.ora file (config
file for Oracle database usually located in $ORACLE_HOME/dbs
directory);
--
Best regards,
rbinek mailto:[EMAIL PROTECTED]
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
