Home » Open Source » Programming Interfaces » Connection time out in Oracle
Connection time out in Oracle [message #270553] Thu, 27 September 2007 08:32 Go to next message
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
Re: Connection time out in Oracle [message #270556 is a reply to message #270553] Thu, 27 September 2007 08:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I think you should post this question in a ASP.NET C# forum: this is not an Oracle problem as you can do it with SQL*Plus.

Regards
Michel
Re: Connection time out in Oracle [message #270730 is a reply to message #270556] Thu, 27 September 2007 21:32 Go to previous message
hapytran
Messages: 2
Registered: September 2007
Junior Member
I solved the problem. The problem is temporary table. I created a temporary table with ON COMMIT DELETE ROWS. When create a temporary table, it should be ON COMMIT PRESERVE ROWS
Previous Topic: Best Approach for integrating AJAX into online Oracle DB
Next Topic: Example of Inserting and Retrieving data from xml file
Goto Forum:
  


Current Time: Tue Dec 03 18:20:52 CST 2024