Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> where to set the Oracle timeout? ORA-02396: exceeded maximum idle time

where to set the Oracle timeout? ORA-02396: exceeded maximum idle time

From: jobs <jobs_at_webdos.com>
Date: Fri, 16 Nov 2007 14:49:03 -0800 (PST)
Message-ID: <853bd8aa-1194-425e-8f83-7674a4f6b243@w34g2000hsg.googlegroups.com>


I got this error while performing an ado.net call to an oracle procedure that returns a dataset.

Exception of type 'System.Web.HttpUnhandledException' was thrown.ORA-02396: exceeded maximum idle time, please connect again System.WebSystem.Exception[]

The process maybe takes 2 to 3 seconds to come back to the webpage.

my vb.net method has cmd.timeout=0

Is my problem there? and is that in minutes or seconds.

My connection string has no timeout setting. Is there a default?

Thanks for any help or information. Received on Fri Nov 16 2007 - 16:49:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US