OraFAQ Forum: Programming Interfaces » Connection time out in Oracle

Home » Open Source » Programming Interfaces » Connection time out in Oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connection time out in Oracle [message #270553]

Thu, 27 September 2007 08:32

hapytran
Messages: 2
Registered: September 2007

Junior Member

Hi,

I have two tables with million of rows. I wrote a stored procedure to process data. It takes much time to process (about one minute, i suppose). When i test with SQL-Plus, it's ok. But when i call it from a small ASP.NET C# page, no data returned.

It seems that connection has been closed (time out) before the stored procedure finished processing. We can set time out in MS SQL Server, but we can not set time out in Oracle. Is it right? Is there any way to solve this problem? How do we process a very big data in oracle?

Thanks

Report message to a moderator

[Message index]

		Connection time out in Oracle By: hapytran on Thu, 27 September 2007 08:32
		Re: Connection time out in Oracle By: Michel Cadot on Thu, 27 September 2007 08:39
		Re: Connection time out in Oracle By: hapytran on Thu, 27 September 2007 21:32

Previous Topic:	Best Approach for integrating AJAX into online Oracle DB
Next Topic:	Example of Inserting and Retrieving data from xml file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 20:01:47 CDT 2024