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

"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