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 -> Re: where to set the Oracle timeout? ORA-02396: exceeded maximum idle time

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

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 17 Nov 2007 07:32:04 +0100
Message-ID: <473e8ae4$0$3124$426a74cc@news.free.fr>

"jobs" <jobs_at_webdos.com> a écrit dans le message de news: 853bd8aa-1194-425e-8f83-7674a4f6b243_at_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.

Have a look at profiles.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_6010.htm#i2065930

Regards
Michel Cadot Received on Sat Nov 17 2007 - 00:32:04 CST

Original text of this message

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